GilaMonster (7/24/2014)
Draconian (7/24/2014)
My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into suspect mode.Suspect or Recovery_Pending? They're two very different statuses. Query sys.databases and please see exactly what the status_desc column is for that database.
Open the error log. There will likely be several errors relating to that database. Please post every message relating to that database, whether you think it relevant or not.
Do you have backups of this database?
That was confusing. On the Database list it was showing Recovery Pendig. When I checked status it was in suspect mode.
SELECT DATABASEPROPERTYEX (N'<dbName>', N'STATUS');
I made enough space on server by moving other databases to different disk. I brought the db in emergency mode and then tried to make it online. and IT WORKED!!
ALTER DATABASE <dbName> SET EMERGENCY;
ALTER DATABASE <dbName> SET ONLINE;
So, I learnt a lesson. Always query database status and dont trust what enterprise manager shows by default along with the database name 😀