Draconian (7/24/2014)
Hi,My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into suspect mode.
My DBSize is around 70GB. I made around 25GB space.
I restarted the SQL Server but it didnt help it is still in recovery pending status.
Pl. help...
Execute below given command and analyze the output:
EXECUTE sp_readerrorlog
You should see somthing like "Recovering the database ...." & along the line it will also tell you the % of recovery completed. Wait for it to complete. If enough space is available then it should come online fine.
Also, ensure that data & log files for the database are intatct & present at their location.