Tuesday 31 January 2017

SQL Server : DB mirroring - Mirrored Database Disconnected

Issue
Recently I came across with an issue in High Performance Database Mirroring setup where mirror database status is showing Disconnected. This was happened due to network issue at particular location in the data centre last night. After once the issue was resolved I have checked the mirrored database status was showing Disconnected.

Resolution
There are two ways to resolve this issue. If the first method does not resolve the issue, use the second method.

Method 1
Recycle the endpoint on the database mirror. To do this, follow these steps:
On the principal database, execute the following SQL script to stop the endpoint:
    ALTER ENDPOINT  STATE=STOPPED
Execute the following SQL script to restart the endpoint:
    ALTER ENDPOINT  STATE=STARTED
Note : If communication between the endpoints does not restart after you execute the scripts, execute the scripts on the database mirror. However, the database may enter a "Suspended" state after you do this. If this issue occurs, execute the following SQL script:
ALTER DATABASE  SET PARTNER RESUME
Method 2
Delete and re-create the database mirroring endpoints on both servers.

In the conclusion, this generally happens because of problems in the SQL Server database mirroring endpoints.

1 comment:

  1. Hi there it's me, I am also visiting this web site regularly, this site
    is truly good and the viewers are really sharing nice thoughts.

    ReplyDelete