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.
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.
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.
In our case we're using certificate authentication for connecting mirroring endpoints, and the issue was because one of the certificates that the mirroring endpoints were using had expired.
You can check the expiration date of the certificate involved in endpoint authentication by doing a
If this is the case, you'll need to create new certificates for whatever expired, then do
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.