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 ENDPOINTExecute the following SQL script to restart the endpoint:STATE=STOPPED
ALTER ENDPOINTNote : 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:STATE=STARTED
ALTER DATABASEMethod 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.SET PARTNER RESUME