Post reply

restoring DBs between SQL 2012 build 11.0.3401.0 and build 11.0.3562.0

  • November 30, 2015 at 4:07 pm

    #302558

    My understanding is that I can restore the DB to a higher version, but not the opposite, is this correct?

    For instance, I can restore build 11.0.3401.0 -> build 11.0.3562.0

    But not ok to downgrade a database, restore from build 11.0.3562.0 -> build 11.0.3401.0

  • December 1, 2015 at 1:51 am

    #1843102

    You can't downgrade from one major version to another (SQL 2012 to SQL 2008 R2). Within a single version, it's usually OK in either direction as most service packs and cumulative updates don't affect the internal database version.

    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

  • December 1, 2015 at 9:12 am

    #1843242

    Thank you Gail!

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

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