Home Forums SQL Server 2008 SQL Server 2008 Administration Can I do restore from database set to 2008 R2 compatibilty on version 2012 instance to 2008 R2 instance? RE: Can I do restore from database set to 2008 R2 compatibilty on version 2012 instance to 2008 R2 instance?

  • November 30, 2016 at 3:31 pm

    #1915295

    trhorner (11/30/2016)

    Application folks and management are very "nervous" to do in-place upgrade

    For good reason. Not something I would do with a prod database myself. Side-by-side (new instance as a named instance) can work if you can't get hardware and the OS will support the new version of SQL.

    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