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.
Udgivet til: Schneider Electric Danmark
Brug for hjælp?
Produktvælger
Find hurtigt og nemt de rette produkter og det rette tilbehør til dine anvendelser.
Få et tilbud
Start din salgsforespørgsel online, så vil du blive kontaktet af en ekspert.
Find forhandler
Find den nærmeste Schneider Electric-distributør.
Hjælpecenter
Find supportressourcer til alle dine behov på ét sted.