The database cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported. Could not open new database. Create database is aborted.

Error:

The database cannot be opened because it is version 661. This server supports version 612 and earlier. A downgrade path is not supported. Could not open new database. Create database is aborted.

Snapshot:

Workaround 1:

You can’t attach newer SQL server databases to older SQL Servers. Nor can you restore a backup from a newer SQL Server to an older SQL Server.

Workaround 2:

SQL Server 2008 R2 databases are 661. SQL Server 2005 databases are version 612. You are trying to attach a 2008 R2 database (v. 661) to a 2005 instance (v. 612) and this is not supported. Once the database has been upgraded to a higher version, it cannot be downgraded.