Principal database in "In recovery" state for a long time.

Question

While i'm testing about SQLServer 2008 mirroring system. The principal server is in "In Recovery" state, and mirror server in "Restoring" state.

How to bring principal server back to online? It's in this state for a day.

Thanks,

Pasagorn P.

Answer 1

I think, the server was restarted sometimes back, while a transaction was going on. There should be an entry in the SQL Server log about the same.

You should wait until the process is complete by SQL Server.

---

SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )

Answer 2

Unfortunately all you can do at that point is wait for recovery to finish. You should check how many VLFs you have. With default settings you quickly end up with a lot and this slows recovery down significantly.

Answer 3

Hi Beersonic,

Regarding to your description, the Principal server is in recovery state might be related to there are lots of transaction log waiting.
For VLFs - http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

If you want to bring the Principal server online the easiest way is Sudeepta mentioned you can try to restart that server. 

---

Regards,
Amber zhang
TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.