Log shipping between sql server versions

• kpmcginn

  Valued Member

  Points: 58

  More actions

  April 9, 2019 at 9:21 pm

  #3071899

  We have two Sql Server instances that are version 12 (11.0.2100.60). One is primary and performs log shipping to the secondary server. The client wants to incrementally upgrade to a current version of Sql Server (either 2016 or later). For the first step of the update, the client would like to update the primary server to the most current version of Sql Server 2012 (11.0.7001.0). This would require that log shipping is between version 11.0.7001.0 to 11.0.2100.60. As I understand, this is viable as it is going from higher version to lower version but I would like validation that I am correct with my understanding.

• Eddie Wuerch

  SSChampion

  Points: 12532

  More actions

  April 10, 2019 at 1:58 am

  #3077488

  You need to update the secondary server first. SQL Server 2012 cannot read transaction log backups from SQL2014 or later.

  https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/upgrading-log-shipping-to-sql-server-2016-transact-sql?view=sql-server-2016

  Eddie Wuerch
  MCM: SQL