Post reply

restore 2012 to 2016

  • January 3, 2017 at 6:55 am

    #320181

    Looking at doing a migration of server and upgrade at same time from 2012 to 2016. TO minimize downtime was looking at doing a full backup and restore of 2012 server to 2016 leaving in standby mode and then at cut over backup and restore transaction logs. Done this with 2008r2 to 2012 not sure if able to with 2016. ANyone tried this path before?

  • January 3, 2017 at 6:58 am

    #1920352

    You can't restore up-version and leave the DB in standby and be able to restore further logs. You'll have to restore WITH NORECOVERY. With that change, your plan will work.

    You've done the pre-upgrade testing?

    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

  • January 3, 2017 at 7:01 am

    #1920356

    just getting started with project plan, trying to get ducks in order

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

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