How to restore database when database was suspect
Author :
Kalpesh Satasiya
Blog :Software Development - Developer | Web Designer Ahmedabad India
Date: 12/15/2011 11:42:00 AM
EXEC sp_resetstatus DataBaseName;
ALTER DATABASE DataBaseName SET EMERGENCY
DBCC checkdb(DataBaseName)
ALTER DATABASE DataBaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (DataBaseName, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DataBaseName SET MULTI_USER