Post reply

Database mirroring

  • December 2, 2013 at 10:45 am

    #301033

    Dear All,

    I have to take a mirrored database 'offline' but I would need to bring them back on line at some point. Is the best practice to remove the mirroring and recreate them again? If thats the case, the mirrored database would be in a 'Restoring' state therefore; would I have to delete the database which is 'restoring' and do a new backup then recreate the mirroring please?

    Thanks in advance!

  • December 2, 2013 at 10:23 pm

    #1670264

    I do not think mirrored database can be taken offline. Depending on what maintenance work you will do, you need to reconfigure it later.

  • December 2, 2013 at 11:39 pm

    #1670272

    why you want to take database offline, want to carry out any specific activities.


    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com

  • December 3, 2013 at 9:00 am

    #1670423

    Thank you for your reply! I want to do some work on the database then restart the mirroring.

  • December 3, 2013 at 9:20 am

    #1670434

    A mirrored DB can't be taken offline, so you would have to break the mirror and then recreate it after you are done with the your work. What work are you doing that you don't want mirrored?


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • January 9, 2014 at 2:45 pm

    #1678986

    Just curious, what work are you doing that requires it to be taken offline? You can reboot the active node in a mirrored relationship and assuming nothing breaks during reboots (s*it happens) the partner will synchronize.

    Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale

  • January 9, 2014 at 8:43 pm

    #1679029

    tt-615680 (12/2/2013)

    Dear All,

    I have to take a mirrored database 'offline' but I would need to bring them back on line at some point. Is the best practice to remove the mirroring and recreate them again? If thats the case, the mirrored database would be in a 'Restoring' state therefore; would I have to delete the database which is 'restoring' and do a new backup then recreate the mirroring please?

    Thanks in advance!

    Are you planning to take the actual mirror server down or you mean take the mirror db offline?

    If you mean the mirror server, it can be down without breaking the mirroring.

    Let me know what exactly you are planning to do.

    Regards,
    SQLisAwe5oMe.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply