Post reply

upgrade service pack

  • May 27, 2014 at 11:54 pm

    #293824

    how to upgrade service packs when the db is configured in logshipping \mirroring in sql 2005\2008?

  • May 28, 2014 at 1:06 pm

    #1717132

    for log shipping, upgrade the secondary first, then the primary. You shouldn't have to stop log shipping. if your secondary is in stand-by then you may have to change secondary to no recovery until both instances are at the same patch version.

    for mirroring you can refer to this article: http://technet.microsoft.com/en-us/library/bb497962(v=sql.105).aspx

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • May 28, 2014 at 2:04 pm

    #1717153

    You could suspend mirroring. Patch and reboot the mirror partner. Resume, wait for sync, and fail over. Then repeat on the other side.

    Similarly with log shipping. Stop the copy / restore jobs. Patch and reboot the secondary. Patch and reboot the primary. Resume the copy and restore jobs.

    JMHO

Viewing 3 posts - 1 through 2 (of 2 total)

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