Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I want to downgrade SQL Server 2008 R2 to SQL Server 2008. I am using Window Server 2008. Any reference documents?

thanks in advance, George

share|improve this question

closed as not a real question by Sam Aug 27 '11 at 12:33

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

3  
Gold badge, silver badges, 119 questions... . And still not learned how to ask questions. What is your question here? If there are documents? Yes, there are documents. But not one that describes any downgrade. –  mailq Aug 26 '11 at 12:31

2 Answers 2

up vote 3 down vote accepted

You cannot. It was never possible with any version to do a downgrade.

And this question is a duplicate of a still answered question: http://stackoverflow.com/questions/3849496/downgrade-sql-server-2008-r2-to-sql-server-2008

share|improve this answer
    
Thanks mailq. I mean downgrade the SQL Server 2008 R2 software itself, not the data file. I think the document is talking about downgrade the data file? Any comments for my requirements? –  George2 Aug 27 '11 at 7:54
1  
Downgrade the software is easy: Uninstall the new one and afterwards install the old one. –  mailq Aug 27 '11 at 9:57
    
Thanks! Question answered. –  George2 Aug 29 '11 at 1:32

There is no way to downgrade an instance. You can uninstall the database instance and install an older version, but you can not take the newer SQL Server 2008 R2 database (or its backup) and attach it to the older SQL Server 2008 instance. This has never been supported.

share|improve this answer
    
Thanks mrdenny. I mean downgrade the SQL Server 2008 R2 software itself, not the data file. I think you are talking about downgrade the data file? Any comments for my requirements? –  George2 Aug 27 '11 at 7:54
1  
There isno way to downgrade the software. You will need to do a full uninstall and install of the older version. –  mrdenny Aug 28 '11 at 21:05
    
Thanks! Question answered. –  George2 Aug 29 '11 at 1:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.