Post reply

log shipping version.

  • June 19, 2013 at 3:13 am

    #274003

    Hello All,

    Please let me know is it possible to create log shipping between two instances with different sql server version.

    Regards

  • June 19, 2013 at 3:39 am

    #1625343

    Log shipping should be possible if the primary instance is of a lower version(say, SQL Server 2005) and the secondary instance is of a higher version(say, SQL Server 2008)

    It will not be possible the other way around. This is because SQL Server does not support restore of backups from a higher version to a lower version.

    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • June 19, 2013 at 3:41 am

    #1625344

    Thanks Kingston

  • June 19, 2013 at 3:43 am

    #1625346

    One more query.

    Please let me know Whether the above rule applies to mirroring and replication also.

  • June 19, 2013 at 3:55 am

    #1625351

    Mirroring yes, though it's not supported, not recommended and not very useful except as part of a rolling upgrade. But then log shipping up-version isn't all that useful either.

    Replication can go down-version. The distributor must be the highest version of any instance involved in the replication

    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

  • June 19, 2013 at 3:59 am

    #1625354

    Thanks Gail

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

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