Attach mdf results in error 948 despite newer sql server version

Anker74
Anker74 used Ask the Experts™
on
Hi Experts

I got this message from my SQL server when trying to attach an mdf database file.

The database 'DNN' cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported.
Could not open new database 'DNN_reflab'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

The server supports version 662 and older but not 661 apparently!!??

Any ideas?
Best regards
Anker
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
661 sure is earlier than 662, so what seems to be the problem? This error message is a bit misleading.
So the error message above should be really read as:

    The database cannot be opened because it is version 661. This server supports versions 662, 655 and earlier than 655. A downgrade path is not supported

With this information the correct resolution can be achieved: the user is trying to attach a SQL Server 2008 R2 database (v. 661) to an SQL Server 2008 SP2 instance. This is not supported. User has to either upgrade the SQL Server 2008 SP2 instance to SQL Server 2008 R2, or it has to attach the database back to a R2 instance and copy out the data from the database into SQL Server 2008 instance database, eg. using the Import and Export Wizard.
Paul JacksonSoftware Engineer
Top Expert 2011
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial