首先先执行离线语句:
Alter Database DBNAME Set Offline with Rollback immediate
之后执行数据库还原语句:
RESTORE DATABASE DBNAME FROM DISK =" + "'" + path + "'" + "WITH REPLACE
最后在执行数据库在线语句:
ALTER DATABASE DBNAME SET ONLINE WITH ROLLBACK IMMEDIATE;
首先先执行离线语句:
Alter Database DBNAME Set Offline with Rollback immediate
之后执行数据库还原语句:
RESTORE DATABASE DBNAME FROM DISK =" + "'" + path + "'" + "WITH REPLACE
最后在执行数据库在线语句:
ALTER DATABASE DBNAME SET ONLINE WITH ROLLBACK IMMEDIATE;