[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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s