SQL Server: Attach incorrect version 661

by

SQL Server 2008 databases are version 655. SQL Server 2008 R2 databases are 661. You are trying to attach an 2008 R2 database (v. 661) 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).

More Related Contents:

  1. Export from SQL Server to Excel
  2. hide/remove header and footer
  3. How do I generate a random number for each row in a T-SQL select?
  4. Auto increment primary key in SQL Server Management Studio 2012
  5. SQL Server Linked Server Example Query
  6. Combine multiple results in a subquery into a single comma-separated value
  7. Infinite loop CTE with OPTION (maxrecursion 0)
  8. SQL Server IN vs. EXISTS Performance
  9. SQL Server: SELECT only the rows with MAX(DATE)
  10. Floor a date in SQL server
  11. How to drop a table if it exists?
  12. PIVOT in sql 2005
  13. SSMS Results to Grid – CRLF not preserved in copy/paste – any better techniques?
  14. EF4 – The selected stored procedure returns no columns
  15. How to do version control for SQL Server database?
  16. Get dates from a week number in T-SQL
  17. What are named pipes?
  18. How to check if a database exists in SQL Server?
  19. tsql returning a table from a function or store procedure
  20. BULK INSERT with identity (auto-increment) column
  21. How to update primary key
  22. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  23. Making an Entity Framework Model span multiple databases
  24. SQL Server 2008 Row Insert and Update timestamps
  25. Full text search does not work if stop word is included even though stop word list is empty
  26. Should I index a bit field in SQL Server?
  27. Setting up maven dependency for SQL Server
  28. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  29. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  30. Escaping single quote in SQL Server

Leave a Comment