论坛 › SQL Server › sqlserver2008数据库置疑的修复方未能

erawrq 发表于 2015-3-30 08:43:25

sqlserver2008数据库置疑的修复方未能

   若在sql server2008上数据实体发生置疑的情况，可用以下方法修复：alter database dbName set emergency

go

alter database dbNameset single_user with rollback immediate

go

use dbName

go

dbcc checkdb

go

use master

go

alter database dbNameRebuild Log on

(name=dbName_log,filename='D:\DataEntry\dbName_log.ldf')

go

select * from sys.databases

go

dbcc checkdb('dbName', repair_allow_data_loss)

go

sp_dboption 'dbName','single user','false'

查看完整版本: sqlserver2008数据库置疑的修复方未能