Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database in suspect mode

Status
Not open for further replies.

lory

MIS
Nov 20, 2001
35
US
Help!! My database ran out of disk space when reindexing in the middle of the night and is now in suspect mode. Once I found out, I deleted some files to release space, but it's been over an hour and it is still in suspect mode. What do I do? Both mdf and ldf were on the same drive.
 
Hi

There is a stored procedure called sp_resetstatus which will change the status of the database and hopefully recover your database for you. Otherwise you might have to restore off your last backup.

Before you execute it read up on it in Books Online under 'supsect database'.

Here is a link to the msdn article about using sp_resetstatus.


Hope this helps

John
 
sp_resetstatus does not recover your database, it just updates a system table in the master database removing the suspect flag. If your database is in a suspect state you should recover it from your latest db & tran log backups.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top