Post reply

Upgrading SQL server service pack on fail over cluster with log shipping

  • January 25, 2019 at 9:44 am

    #379125

    Hello,
    We have 3 SQL servers with fail over cluster and two of them are configured with log shipping.
    Current Version: SQL Server 2012 Service Pack 3
    Upgrading to SQL Server 2012 Service Pack 4

    Server A - Part of Fail over cluster with log shipping (Primary server)
    Server B - Part of fail over cluster
    Server C - Part of fail over cluster with log shipping (Secondary server).

    This is the first time i am upgrading fail over cluster with log shipping and as this is a very critical server, i have to be extra careful.
    Can anyone please provide the correct way to upgrade all three SQL server?

  • January 29, 2019 at 9:45 am

    #2020450

    First, you need to set up test instances and test. DO NOT JUST TAKE ADVICE. You have to test things. You don't need a copy of production, but you need these versions setup with a test db and validate that you can connect.

    In general, SPs should not change db versions, but to be careful, you upgrade downstream first. I'd do the log shipping target first, then the secondary, then fail over and do the primary.

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

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