Home Forums SQL Server 2016 SQL Server 2016 - Administration SQL Server Upgrade from 2008 Standard to 2014 or 2016 RE: SQL Server Upgrade from 2008 Standard to 2014 or 2016

  • August 25, 2016 at 5:26 pm

    #1897685

    Detach/Attach can only be done with databases in the same SQL Server compatibility mode - meaning you can only for example Detach/Attach a 2016 database in the SQL server 2016 version; whereas a SQL Server 2008 database backup can be restored onto another version of SQL, say, SQL Server 2016.