Post reply

log shipping between different Service Pack levels

  • March 14, 2017 at 9:58 am

    #319547

    Does anybody know of any issues regarding log shipping if you primary is running SQL2012 Standard SP2 and your Standby server is running SQL2012 Standard SP3. Does it even matter ?

  • March 14, 2017 at 10:36 am

    #1933073

    PearlJammer1 - Tuesday, March 14, 2017 9:58 AM

    Does it even matter ?

    No.
    From 2012 to SQL 2014 would be a problem (well, failover is fine, failback wouldn't be possible), but the service packs don't bump the internal DB version, so doesn't bother log shipping.

    That said, you should patch the SP2 box sometime.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 14, 2017 at 10:52 am

    #1933084

    Thanks Gail.

    Yes we will patch the SP2 box at some point.

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

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