Hello ajitkumar,
Could you tell me what version of your SQL Server and post the error message in the SQL Server Error log?
If you are using SQL Server 2005/2008/2008 R2, Mirrored databases are disconnected after you restart the database mirror. That is caused by SQL Server mirroring endpoints, here is two solutions:
Solution 1: Recycle the endpoint on the database mirror.
On the principal database, execute the following SQL script to restart the endpoint:
ALTER ENDPOINT <Endpoint Name> STATE=STOPPED
ALTER ENDPOINT <Endpoint Name> 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 <Database Name> SET PARTNER RESUME
Solution 2:
Delete and re-create the database mirroring endpoints on both servers.
More detail, you can refer to https://support.microsoft.com/en-us/help/2490051/mirrored-databases-are-disconnected-after-you-restart-the-database-mir
Hope it will help. If it cannot solve your issue, please tell me the version of SQL Server and error message, thanks.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.
