Tell me more ×
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.
up vote 0 down vote favorite

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

migrated from stackoverflow.com Nov 24 '11 at 0:19

2 Answers

up vote 3 down vote

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
up vote 2 down vote

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

 
discard

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