1

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.

migrated from stackoverflow.com 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
  • 1
    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
4

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.

2

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, privacy policy and cookie policy