Exclusive access could not be obtained because the database is in use
Use Master
Alter Database YOURDB
SET SINGLE_USER With ROLLBACK IMMEDIATE
RESTORE DATABASE YOURDB
FROM DISK = 'C:Program FilesMicrosoft SQL ServerMSSQLBACKUPYOURDB.bak'
use Master
ALTER DATABASE yourdatabasename SET MULTI_USER WITH ROLLBACK IMMEDIATE;
[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8337095/viewspace-1060178/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
没有了~
请登录后发表评论
登录
全部评论
最新文章
- select the lock block in MSSQL
- startup and shutdown RAC
- housekeep arch logs (tested on AIX)
- ora-00119, ora-00131
- crsctl start crs for RAC on PRD
- wmi provider error 0x800742a2 :: MSSQL instance can not start
- [转载牛人教程和自己的实验结果] 7.手工备份恢复--复制数据库(练习9)
- ORA-12560
- Stop runnung job
- upgrade to 11g--control file 惊魂记
