Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The failover server has status (Mirror, Disconnected, In recovery) and principal server has status (Principal, Disconnected).

What is the process to reconnect these servers?

share|improve this question
    
Here's a related question that looks very similar to this one. Give it a look and see if it helps: Breaking and Restoring a mirror Here's are some quick steps on how to Pause or Resume Database Mirroring If you're still having trouble after reading through those, update your post with what you've all tried and we'll go from there. –  BryceAtNetwork23 Jan 3 '12 at 17:16
add comment

migrated from serverfault.com Jan 3 '12 at 16:14

This question came from our site for professional system and network administrators.

2 Answers

First, try to get them to reconnect with this T-SQL command on the principal:

ALTER DATABASE AdventureWorks2012 SET PARTNER RESUME;

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.

share|improve this answer
add comment

Sometimes restarting the mirroring endpoint on the principal server will resolve this.

To do this use the following T-SQL.

ALTER ENDPOINT Endpoint_Name STATE = STOPPED

ALTER ENDPOINT Endpoint_Name STATE = STARTED

To get the name of the endpoint.

SELECT * FROM sys.endpoints
WHERE type = 4

See KB 2490051 for more details.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.