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.

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

2 Answers 2


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.


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.