你确定是按照上面的操作做的吗?
换一下试试,启动后
use master
go
sp_configure "allow updates to system tables",1
go
update sysdatabases set status=0 where name="db_name"
go
use db_name
go
dump tran db_name with no_log
重新启动SQL
如果还有问题把错误日志贴出来看看
现象 Error926 数据库标志为suspect状态解决办法:
sp_configure "allow updates to system tables",1
begin tran
use master
update sysdatabases set status=-32768 where name="db_name"
返回1 commit tran
else rollback tran
重新启动SQL server
use db_name
dump tran db_name with no_log
update sysdatabases set status=0 where name="db_name"
重新启动 SQL server
dbcc checkdb(db_name)