Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 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
add comment

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.

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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