Issue
A user receives an error when restoring or attaching SQL database from SQL 2012 to earlier version of SQL server
"The database cannot be opened because it is version 706. This server supports version 663 and earlier"
Product Line
SQL Server 2012 and SQL Server 2008 R2
StruxureWare Power Monitoring (SPM) 7.x
Power Monitoring Expert (PME) 7.2.x and 8.x
Environment
Microsoft SQL Server Management
Cause
SQL 2008 R2 cannot attach database files that were created from or attached to SQL 2012
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
PME7.2.2 systems running SQL server 2008 R2 cannot attach database files that were created from SQL 2012.
Upgrading SQL server 2008 R2 to SQL 2012 must be done if restoring or attaching a database from SQL2012 is required.
A user receives an error when restoring or attaching SQL database from SQL 2012 to earlier version of SQL server
"The database cannot be opened because it is version 706. This server supports version 663 and earlier"
Product Line
SQL Server 2012 and SQL Server 2008 R2
StruxureWare Power Monitoring (SPM) 7.x
Power Monitoring Expert (PME) 7.2.x and 8.x
Environment
Microsoft SQL Server Management
Cause
SQL 2008 R2 cannot attach database files that were created from or attached to SQL 2012
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
Reason of the error message:
The database was created in/attached to SQL Server 2012 version. Now this database is being attached to SQL Server 2008 R2.
The database was created in/attached to SQL Server 2012 version. Now this database is being attached to SQL Server 2008 R2.
Error when restoring database:
Version 706 is a database file from SQL Server 2012
Version 663 is a database file from SQL Server 2008 R2
PME7.2.2 systems running SQL server 2008 R2 cannot attach database files that were created from SQL 2012.
Upgrading SQL server 2008 R2 to SQL 2012 must be done if restoring or attaching a database from SQL2012 is required.
Released for: Schneider Electric United Arab Emirates
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales enquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Centre
Find support resources for all your needs, in one place.
