Can I do restore from database set to 2008 R2 compatibility on version 2012 instance to 2008 R2 instance?

  • I posted this on the 2008 admin forum, but thought I would place it here also.

    I am putting together a "recovery" plan if hardware fails, and since the business allows 120 minute recovery window,

    I plan to do full and log backup restores of the production databases instead of using an HA technique. I know,

    I can use log shipping, but cost of additional hardware prevents that, so here is my question.

    The production databases are on version 2008 R2. The plan is to do restores from the 2008 R2 backups to version 2012

    that is on a standby server. I will definitely not change the compatibility setting on the databases. Users will then

    utilize those databases until the hardware is fixed. Can I perform backup of the databases on the standby server (version

    2012 but compatibility set to 2008 R2) and restore that backup to the 2008 R2 database on the production (now fixed) server?

  • Please don't post multiple threads for the same question.

    No replies here. Replies to http://www.sqlservercentral.com/Forums/Topic1838679-1550-1.aspx

    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
  • Normally I would agree, but in this case I was going across two versions. That being said, I have received my answer so no need for anyone on this forum to respond. Thanks!

  • trhorner (11/29/2016)


    Normally I would agree, but in this case I was going across two versions. That being said, I have received my answer so no need for anyone on this forum to respond. Thanks!

    Crossing versions is no reason to cross post. If you look up above the thread you will see a navigation link called Recent Posts. Most of us that answers questions use that to find new posts that may need help. That's how we find the cross posts.

  • trhorner (11/29/2016)


    Normally I would agree, but in this case I was going across two versions.

    Two, three, four versions, same thing. Multiple threads means mixed up replies, answers being posted to answered questions. Pick the best forum, put the thread there.

    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

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

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