Repair DB

-- Suspect

Use master
go
Alter database DBName set emergency

Alter database DBName set single_user

DBCC CHECKDB(DBName ,REPAIR_REBUILD)

-- if REPAIR_REBUILD cannot reapir, run repair_allow_data_loss and some data lost

DBCC CHECKDB(DBName ,repair_allow_data_loss) WITH no_infomsgs,all_errormsgs

Alter DATABASE DBName SET ONLINE

Alter DATABASE DBName SET multi_user

-- 參考
-- <DBCC CHECKDB (Transact-SQL)>