22 Mei 2012 6:06
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.
22 Mei 2012 7:51
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 )
23 Mei 2012 6:29Unfortunately 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.
23 Mei 2012 9:38Moderator
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.
TechNet Subscriber Support