SQL Server – Cannot detach a suspect or recovery pending database

---

I tried to detach the database in one of our SQL servers, but received the following error:-

 

Cannot detach a suspect or recovery pending database. 
It must be repaired or dropped. (Microsoft SQL Server, Error: 3707)

 

---

To resolve i did the following steps:-

ALTER DATABASE AdventureWorks2012 SET EMERGENCY;
GO

 

• In EMERGENCY mode database marks as READ_ONLY and also disabled the logging.
• In EMERGENCY mode sysadmins also having the limited access.
• Marking the database in EMERGENCY mode is a first step for resolving log corruption.

 

ALTER DATABASE AdventureWorks2012 set single_user
GO
DBCC CHECKDB (AdventureWorks2012, REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS;
GO
ALTER DATABASE AdventureWorks2012 set multi_user
GO

 

Above steps resolve any corruption and bring the database online and The database will come out of EMEREGENCY mode automatically in Sql Server.

---