Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I installed SQL Server 2008 R2 just now and wanted to attach my previous databases. Attaching a Database gives an error.

Attached is the image of the error.

enter image description here

Any Suggestions and help will be appreciated. :) Regards.

share|improve this question

migrated from Nov 24 '11 at 0:19

This question came from our site for professional and enthusiast programmers.

Upgrade database version? – danihp Nov 6 '11 at 11:12
how do i upgrade it to SP1? i think upgradation is required.. – Abid Ali Nov 6 '11 at 11:18
Show to us that you did install SQL Server 2008 R2 by doing SELECT SERVERPROPERTY('productversion') or SELECT @@VERSION and post the output. – Shawn Melton Nov 24 '11 at 1:11

Something seems not quite right with your question.

SQL 2008 is version 655 SQL 2008R2 is version 661

I would expect that you would only see that error if you are attempting to attach a 2008R2 DB to 2008, not vice versa.

As soon as you attach a DB to 2008 R2, the version is changed to 661 and can no longer be attached to a 2008 server.

share|improve this answer

Your SQL Server Management Studio install may be SQL 2008 R2, but I'm guessing your SQL Server database engine is SQL 2008.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.