SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cannot attach database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Waxhill
Starting Member

2 Posts

Posted - 10/12/2010 :  05:29:08  Show Profile  Reply with Quote
I'm trying too attach a database from SQL Server Express onto SQL Server R2, but am getting the following error:

The database ... cannot be opened because it is version 661. This server supports version 662 and earlier.

661 is definitely earlier than 662! Any ideas anyone?

Thanks in advance.

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/12/2010 :  06:14:26  Show Profile  Reply with Quote
Don't know the answer, but can you make & use a Backup file instead?
Go to Top of Page

kishore_pen
Starting Member

49 Posts

Posted - 10/12/2010 :  06:49:10  Show Profile  Reply with Quote
check the below link for your query:
http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/12/2010 :  06:58:21  Show Profile  Reply with Quote
That's going the other way isn't it? i.e. SQL 2008 R2 back to SQL 2008 RMT/SP1
Go to Top of Page

Waxhill
Starting Member

2 Posts

Posted - 10/12/2010 :  11:36:59  Show Profile  Reply with Quote
You are correct - there are plenty of articles about not being able to use a database from a later release, but not an earlier one!

In the end, a complete re-install of SQL Server has fixed it. A pain on my dev machine and it wouldn't be acceptable on a production server, so I'd still like to get to the bottom of it!
Go to Top of Page

remusrusanu
Starting Member

2 Posts

Posted - 11/23/2010 :  11:27:05  Show Profile  Visit remusrusanu's Homepage  Reply with Quote
Same answer as I gave on http://stackoverflow.com/questions/4257684/sql-server-attach-incorrent-version-661/4258260#4258260:

SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database (v. 655) to an 2008 instance and this is not supported. Once the database has been upgraded to an 2008 R2 version, it cannot be downgraded. You'll have to either upgrade your 2008 SP2 instance to R2, or you have to copy out the data in that database into an 2008 database (eg using the data migration wizard, or something equivalent).

The message is misleading, to say the least, it says 662 because SQL Server 2008 SP2 does support 662 as a database version, this is when 15000 partitions are enabled in the database, see Support for 15000 Partitions.docx. Enabling the support bumps the DB version to 662, disabling it moves it back to 655. But SQL Server 2008 SP2 does not support 661 (the R2 version).


http://rusanu.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000