24 Oct 2017 
Support Center » Knowledgebase » SUSPECT MODE DB RECOVERY
 SUSPECT MODE DB RECOVERY
Article Recovering SQL Server Database From Suspect Mode
Follow below steps to recover database from suspect mode:

1. ALTER DATABASE [adminv2] SET EMERGENCY
2. DBCC checkdb(adminv2)
3. ALTER DATABASE [adminv2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
4. DBCC CheckDB (adminv2, REPAIR_ALLOW_DATA_LOSS)
5. ALTER DATABASE [adminv2 SET MULTI_USER


Article Details
Article ID: 57
Created On: 29 Nov 2014 6:48 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
E-mail:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Knowledgebase | Troubleshooter | News | Downloads
Language:

Help Desk Software by Kayako SupportSuite v3.40.01