{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
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.

Schneider Electric Hong Kong

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: