Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Waxhill
Starting Member
2 Posts |
Posted - 2010-10-12 : 05:29:08
|
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
22859 Posts |
Posted - 2010-10-12 : 06:14:26
|
Don't know the answer, but can you make & use a Backup file instead? |
|
|
kishore_pen
Starting Member
49 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2010-10-12 : 06:58:21
|
That's going the other way isn't it? i.e. SQL 2008 R2 back to SQL 2008 RMT/SP1 |
|
|
Waxhill
Starting Member
2 Posts |
Posted - 2010-10-12 : 11:36:59
|
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! |
|
|
remusrusanu
Starting Member
2 Posts |
Posted - 2010-11-23 : 11:27:05
|
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 |
|
|
|
|
|
|
|