How to Restore Backup Database from SQL 2005 to SQL 2012
Issue:
When trying to restore a SQL 2005 database in SQL 2012, the Database Restore will give the following error: “The database was backed up on a sever running version 8.002065. That version is incompatible with this server, which is running version 11.00.3000.”
Product Line:
Power Monitoring Expert v7.2.2
Environment:
SQL Server Management Studio
Cause:
It is not possible to restore a SQL 2005 database directly to SQL 2012.
Resolution:
1) Restore the SQL 2005 database backup on a SQL Server 2008 system.
2) Take a backup of the database from the SQL 2008 system.
3) Restore the SQL 2008 database backup on the SQL 2012 system.
When trying to restore a SQL 2005 database in SQL 2012, the Database Restore will give the following error: “The database was backed up on a sever running version 8.002065. That version is incompatible with this server, which is running version 11.00.3000.”
Product Line:
Power Monitoring Expert v7.2.2
Environment:
SQL Server Management Studio
Cause:
It is not possible to restore a SQL 2005 database directly to SQL 2012.
Resolution:
1) Restore the SQL 2005 database backup on a SQL Server 2008 system.
2) Take a backup of the database from the SQL 2008 system.
3) Restore the SQL 2008 database backup on the SQL 2012 system.
Publicerad för: Schneider Electric Sverige
Behöver du hjälp?
Produktväljare
Hitta snabbt och enkelt rätt produkter och tillbehör för dina ändamål.
Begär en offert
Ställ din fråga online så kontaktar vi dig.
Här köper du
Hitta enkelt närmaste Schneider Electric-distributör på din ort.
Hjälpcenter
Hitta alla supportresurser som du behöver på ett ställe.