Post reply

configuring log shipping from 2008 to 2005

  • October 13, 2012 at 6:33 am

    #263875

    can we configure below logshipping setup

    Prmiary: SQL Server 2008

    Secondary Server 2005 with Standby Mode

    would it work? can any one suggest me?

  • October 13, 2012 at 7:27 am

    #1548882

    Cannot be done. Databases can never be downgraded.

    For log shipping with standby, the secondary must be the same version as the primary. If you're restoring with norecovery, the secondary can be a higher version, but never a lower.

    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

  • October 14, 2012 at 2:28 am

    #1548934

    sreenubabu.s (10/13/2012)

    can we configure below logshipping setup

    Prmiary: SQL Server 2008

    Secondary Server 2005 with Standby Mode

    would it work? can any one suggest me?

    The only way you "could" get the data on a lower version of sql is to use replication. This could be scheduled in a similar manner to log shipping if you wished

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

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