locked
when mirror server restated why mirror db disconneted . RRS feed

  • Question

  • hi

    when mirror  server restated  why mirror dB disconnected .

    pleased  give me proper solutions , I never want to configure regain


    ajitkumar

    Wednesday, February 19, 2020 7:18 AM

All replies

  • Hi

    This issue may occurs because of problems in the SQL Server database mirroring endpoints.

    Try this Method- 

    Recycle the endpoint on the database mirror. To do this, follow these steps:
    1. On the principal database, execute the following SQL script to stop the endpoint:
      ALTER ENDPOINT <Endpoint Name> STATE=STOPPED
    2. Execute the following SQL script to restart the endpoint:
      ALTER ENDPOINT <Endpoint Name> STATE=STARTED

    This may help

    Wednesday, February 19, 2020 7:25 AM
  • 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.



    Thursday, February 20, 2020 1:45 AM
  • Hello,
    Have you solved the question?
    If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members finding and reading the thread easily. Make the furm more helpful that's what we are working.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    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.

    Monday, February 24, 2020 1:02 PM