• 数据库修复

exec sp_dboption 'dbname1','single user',‘true’

dbcc checkdb('dbname1')

dbcc checkdb('dbname1',REPAIR_FAST)

dbcc checkdb('dbname1',REPAIR_REBUILD)

dbcc checkdb('dbname1',REPAIR_ALLOW_DATA_LOSS)

 

exec sp_dboption 'dbname1','single user',‘false’

 

• 单表修复

exec sp_dboption 'dbname1','single user',‘true’

dbcc checktable('需要修复的数据表的名称',REPAIR_ALLOW_DATA_LOSS)      

dbcc checktable('需要修复的数据表的名称',REPAIR_REBUILD)

exec sp_dboption 'dbname1','single user',‘false’

 

sql2014

alter database dbname1set SINGLE_USER with ROLLBACK IMMEDIATE

dbcc checkdb('dbname1')

dbcc checkdb('dbname1',REPAIR_FAST)

dbcc checkdb('dbname1',REPAIR_REBUILD)

dbcc checkdb('dbname1',REPAIR_ALLOW_DATA_LOSS)

 

exec sp_dboption 'dbname1','single user','false'

alter database dbname1 set MULTI_USER with ROLLBACK IMMEDIATE