[Solved] Database status In Recovery

We have configured Mirroring on SQL server 2008 R2 as HA on different site and today I saw on Principle DB server that all Databases are in disconnected mode so tried lot and then finally stopped and restarted SQL server Service.

Then opened SQL Management studio and surprised to see databases status was (In Recovery), waited for some and tried by refresh but no change in database status. Even databases was not accessible

So executed command


Clicked on refresh button and seen all databases status changed to (Principal, Synchronized) J


Prashant Deshpande


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s