March 10, 2006 at 7:46 am
Hello
One of my cleints had a power outage.
The database came up but was marked suspected. They said they tried to detach the DB and SQL Server didn't allow them. So they restarted the server.
Since then we have not been able to attached the DB
BElow is the message I get when I try to run sp_attach.
----
Server: Msg 926, Level 10, State 1, Line 1
Database 'PRR_PROD' cannot be opened. It has been marked SUSPECT by recovery.
March 10, 2006 at 9:09 am
There are a couple of thing you can try like changing the status with the sp_resetstatus (BOL)if its too damaged then it might not work if the database is extensively damaged.
The other option is a restore from your latest backup. Make sure you run DBCC CHECKDB and DBCC CHECKCATALOG
Good luck
March 13, 2006 at 1:45 am
Put the database in the emergency mode,
then use sp_resetstatus to change the status flag on the database..and then restore the database from the backup...
..hema
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply