up vote 0 down vote favorite
1
share [g+] share [fb]

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

link|improve this question
59% accept rate
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
feedback

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. See the FAQ for guidance on how to improve it.

2 Answers

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

link|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
feedback
up vote 1 down vote

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.

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

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