数据库被SUSPECT(置疑)解决方案

2014-11-24 15:31:20 · 作者: · 浏览: 0
数据库被SUSPECT(置疑)解决方案
How to recover SQL Server database from suspect mode
Java代码
EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER