Downgrading version

Question

Downgrading version

VastSQL

SSC-Dedicated

Points: 36097
More actions
October 19, 2012 at 4:38 am

#263587

Can we downgrade SQL server version? Example 10.50.2861 to 10.50.2789

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

Microsoft doesn't support backward compatibility like that. However, you can try. You'd have to uninstall SQL Server and the install the older version. You'll want to test a backup and restore of your databases prior to attempting it. If you can't restore the database to an older version, which is possibly the case, then you'll have to plan on exporting all the database structures and data to get them moved to the older version. In short, this is going to be a dangerous operation.

Why do you need to do this?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

Grant Fritchey (10/19/2012)
Why do you need to do this?

My guess ..interview Question 😛

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Lowell SSC Guru Points: 323518 More actions · Answer 3

Ratheesh.K.Nair (10/19/2012)
Can we downgrade SQL server version? Example 10.50.2861 to 10.50.2789

you would have to uninstall 8 different cumulative updates, it looks like to me:

from http://sqlserverbuilds.blogspot.com/

see the number of rows different on that page.

i guess the better question is why you feel you have to do this? are you getting a specific error or issue?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 4

Just for testing. Successfully downgraded by using uninstall updates under the UNISTALL PROGRAMS.