Monthly Archives: March 2016

[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

ALTER
ENDPOINT Mirroring STATE
=
STARTED

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

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under Uncategorized