January 14, 2010 at 6:08 pm
Hello All,
One of my databases on SQL SERVER 2005 is showing in recovrey mode
DBNAME ( In Recovery) . I dont have the full backup for the database. I tried DBCC RESETSTATUS , but it is showing Suspect Mode status is already reset. In sp_who2 i have checked there are active processes for this database name.
Can you please suggest the same.
January 14, 2010 at 9:04 pm
Please check the error log for an indication of what it going on and post anything you find.
January 15, 2010 at 1:38 am
Is the state 'recovering'? (check sys.databases)
If so, look in the error log, there'll be lots of messages saying that the database is recovering and how much longer is estimated. All you can do at this point is wait.
If the state in sys.databases is something other than 'recovering', or there are other messages in the log, please post details here.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply