Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Database is in recovery mode

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-08-04 : 20:04:55
Hi,

It seems sql server has been restarted and user database is in recovery mode. Recovery model of this database is simple. Any issue? How to proceed? Thanks!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-08-05 : 12:26:11
What does the error log say?

If there are messages like this, it's normal and you just need to wait until recovery is complete
"Recovery is 50% complete (Phase 2 of 3) estimated time remaining 3432 seconds"

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -