sql offline and online

最新推荐文章于 2024-12-06 12:13:02 发布

wogeiniziyou

最新推荐文章于 2024-12-06 12:13:02 发布

阅读量423

点赞数

本文链接：https://blog.youkuaiyun.com/wogeiniziyou/article/details/7865769

版权

    USE Master  
    GO  
    ALTER DATABASE CQMineOA SET OFFLINE WITH ROLLBACK IMMEDIATE  
    GO  
    restore database CQMineOA from disk = 'e:\CQMineOA.bak'     
    WITH MOVE 'CQMineOA' TO 'E:\db\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\CQMineOA.mdf',  
    MOVE 'CQMineOA_log' TO 'E:\db\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\CQMineOA.ldf',  
    replace,NOUNLOAD,STATS=10   
    GO  
    alter   database  CQMineOA  set   online    
    GO