The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected).
What is the process to reconnect these servers?
migrated from serverfault.com Jan 3 '12 at 16:14
This question came from our site for system and network administrators.
First, try to get them to reconnect with this T-SQL command on the principal:
If that fails, you've got a communications issue between the principal and the mirror, and that's where the fun begins. It can be anything from IP connectivity to security on the mirroring endpoints to different encryption methods. I'd recommend Robert Davis's book Pro SQL Server 2008 Mirroring if you need to get into deep troubleshooting.
Sometimes restarting the mirroring endpoint on the principal server will resolve this.
To do this use the following T-SQL.
To get the name of the endpoint.
See KB 2490051 for more details.
When you run below command on Principal server:
After running above command your DB goes in
Step 1:Run below query on mirror
Step 2: After running below command your DB will be available.
Note: Step 2 will take some time to recover.