November 27, 2007 at 8:28 am
I was asked to increase a secondary data file (.ndf) from 2GB to 4GB on a user database. Unfortunately while I was doing this the server more or less ground to a halt and the tempdb had filled the small drive that it resides on.
I stopped and started the SQl Server services to reduce the tempdb but when SQl came back the user database was In Recovery mode and cannot be accessed, I can't therefore detatch, attach, take of-line, restore - can anyone advise on how to get this database back ??
November 27, 2007 at 8:41 am
One way will be to free some space on your drive where your files (.mdf or .ndf or .ldf)are which are taking up all the disk space.
When u have enough space on disk, SQL will start.
If ur Database is in suspect moode then try this link:
http://qa.sqlservercentral.com/articles/Administering/unmarksuspect/137/
November 28, 2007 at 12:10 pm
Have you tried to switch the database out of recovery mode?
restore database databasename with recovery
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply