sql 数据库修复

数据库修复

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’

单表修复

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

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

sql2014

alter database dbname1set SINGLE_USER with ROLLBACK IMMEDIATE

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

alter database dbname1 set MULTI_USER with ROLLBACK IMMEDIATE