Cannot be opened because it is version 706. This server supports version 661 and earlier

Posted on March 22, 2012 by chanmingman

The you attach a database to SQL Server 2008 R2. The first error you hit is.

——————————

An error occurred when attaching a database(s).

——————————

When you click the hyper link you see the error as below.

——————————

The database ‘COMMERCE’ cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.

Could not open new database ‘COMMERCE’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

——————————

This is because your database is from SQL Server 2012. The only way to resolve this as I found is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2.

The video below shows how to generate script from SQL Server 2012. Unfortunately the data you need to export them separately.

Generate Script

About these ads

About chanmingman

Ming Man is a senior manager for a development company. With 20 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.

View all posts by chanmingman →