-- Attempt repair suspect database
USE master;
GO
-- Set database in EMERGENCY read only state
ALTER DATABASE MyDB SET EMERGENCY
GO
-- Set database in SINGLE_USER state
ALTER DATABASE MyDB SET SINGLE_USER
GO
USE MyDB
DBCC CHECKDB(MyDB) WITH NO_INFOMSGS -- Run integrity Check
-- DBCC CHECKDB (MyDB, REPAIR_REBUILD) WITH NO_INFOMSGS -- Repair database with no dataloss
-- DBCC CHECKDB (MyDB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS -- Repair database with possible dataloss
GO
-- Set database in MULTI_USER state
ALTER DATABASE MyDB SET MULTI_USER
GO
_________________________________________________________________