1
How to Recovering SQL Server Database from Suspect Mode
Problem reported by Greg C. - June 19, 2015 at 7:45 PM
Submitted
Employee Post
1) EXEC sp_resetstatus 'ACTEmailRelay'
2) ALTER DATABASE ACTEmailRelay SET EMERGENCY
3) DBCC checkdb('ACTEmailRelay')
4) ALTER DATABASE ACTEmailRelay SET SINGLE_USER WITH ROLLBACK IMMEDIATE
5) take the backup of the database.
6) DBCC CheckDB ('ACTEmailRelay', REPAIR_ALLOW_DATA_LOSS)
7) ALTER DATABASE [ACTEmailRelay]  SET MULTI_USER

Reply to Thread