none
Mirroring Suspended State RRS feed

  • Question

  • HI,

      We have sql mirroring configured in our environment. Every month we are restating DR DB Servers for OS patchs/maintenance activities. During this time few databases are changing their mode to suspended. Please let us know the best practice to restart DB servers with out such issues.  As of now we are restarting db servers straight away. Do we need to pause the mirroring? We have hourly Tx backups configured.

    Thanks,

    Varun 

    Friday, July 3, 2015 7:09 AM

Answers

  • Hi Varun,

    Generally, it is better to perform the following steps in the scenario that rebooting servers.

    1. Make sure that databases are synchronized on the principal server and mirror server.

    2. Pause database mirroring with the following commands.

    ALTER DATABASE <database_name> SET PARTNER SUSPEND

    3. Resume database mirroring by using the following Transact-SQL statement after implementing OS patchs/maintenance activities.

    ALTER DATABASE <database_name> SET PARTNER RESUME

    There are a similar blog and a similar thread for your reference:
    Stop mirroring for server reboot
    Pausing DB Mirror



    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Monday, July 6, 2015 3:39 AM
    Moderator

All replies

  • https://msdn.microsoft.com/en-us/library/bb497962.aspx?f=255&MSPPError=-2147217396 

    This help you.


    Vote As Helpful if it helps to solve your issue

    Friday, July 3, 2015 2:50 PM
  • Hi Varun,

    Generally, it is better to perform the following steps in the scenario that rebooting servers.

    1. Make sure that databases are synchronized on the principal server and mirror server.

    2. Pause database mirroring with the following commands.

    ALTER DATABASE <database_name> SET PARTNER SUSPEND

    3. Resume database mirroring by using the following Transact-SQL statement after implementing OS patchs/maintenance activities.

    ALTER DATABASE <database_name> SET PARTNER RESUME

    There are a similar blog and a similar thread for your reference:
    Stop mirroring for server reboot
    Pausing DB Mirror



    Thanks,
    Lydia Zhang


    Lydia Zhang
    TechNet Community Support




    Monday, July 6, 2015 3:39 AM
    Moderator
  • Before maintenance window please pause the mirroring and restart once the servers are up you can resume the mirroring. Either you can do this via commands as Lydia suggested above or from GUI.

    Choose mirroring monitor, there you can see the suspend option.


    Regards, Pradyothana DP. Please Mark This As Helpful if it helps to solve your issue. ========================================================== https://social.technet.microsoft.com/Profile/pradyothanadp http://www.dbainhouse.blogspot.in/

    Monday, July 6, 2015 4:09 AM
  • HI Lydia Zhang,

      Thanks for the reply. One doubt I have is We have tx backup running on Prod server. Please let me know post exec ALTER DATABASE <database_name> SET PARTNER SUSPEND   if a tx backup gets fired..  Does mirroring comesup normally?

    Please help...

    Thanks,

    Varun

    Friday, July 17, 2015 6:26 AM
  • tx backup gets fired according to your schedule, nothing to do with mirroring.

    After pausing mirroring, resume it as Lydiia refers, everything will ok
    Monday, July 20, 2015 8:24 AM