Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to uninstall/rollback SQL 2000 Sp4 Expand / Collapse
Author
Message
Posted Tuesday, March 13, 2007 9:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 25, 2010 12:24 PM
Points: 79, Visits: 17

Hi All,

Just been handed a query to rollback a production SQL Server to SP3a. The server is running SQL 2000 Enterprose Edition with Sp4. The upgrade to Sp4 was done over 4 months back and we need to retain changes to users SQL accounts that have been made during this time. Worst of all, I do not have a backup of the Sp3a version of the system databases . Does anyone have any bright ideas?

Thank you in advance...

Post #351167
Posted Tuesday, March 13, 2007 10:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 5,386, Visits: 9,962

Kumaran

The only way I know is like this:

(1) Script out your logins, jobs and so on
(2) Back up your user databases
(3) Uninstall SQL Server
(4) Install SQL Server RTM
(5) Apply SP3a
(6) Restore your user databases
(7) Generate a script to drop and create the users in your user databases
(8) Run the script so that the users are created with SIDs that match the server logins

Good luck!
John

Post #351190
Posted Wednesday, March 14, 2007 9:54 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 14, 2014 10:42 AM
Points: 3,527, Visits: 82

You can not uninstall an SP in SQL Server.

I would have done the same as John stated.

But, what is the reason that they want to go back to SP3a?

Al

Post #351507
Posted Wednesday, March 14, 2007 10:18 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 25, 2010 12:24 PM
Points: 79, Visits: 17

The customer decides that after 4 months of the server being in production, the application has an issue with SQL2k Sp4. It seem to me a badly designed app. Most probably a development team without a DBA, thinking they can design and optimise their DB without the need of a DBA...

Supprisingly , they do say that it is compatible with SQL 2005 but this is "not confirmed", they said the exact words when we were installing Sp4...

Post #351521
Posted Wednesday, March 14, 2007 1:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 2:37 AM
Points: 48, Visits: 137
I can easy follow Al.
It's my responsibility as a DBA to secure the data, and the security issues handled in SP4 are too grave to allow a roolback to SP3a.
Management (the top) has to sign off!
This is not a technical or an application problem - it's a business problem.


/Niels Grove-Rasmussen
Post #351571
Posted Thursday, March 19, 2009 11:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 29, 2011 12:26 PM
Points: 127, Visits: 211
Just curious... Did you rollback to SP3a and if so, what was your experience?


Post #679742
Posted Thursday, March 19, 2009 12:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 25, 2010 12:24 PM
Points: 79, Visits: 17
Hi,

Not really, we eventually upgraded to SQL 2005.

On the flip side, I did try this in a lab by manually changing DLL's and so forth and reverting to old system DB's and using SQL Compare to change any structural changes on the user DB's. I eventually gave up after a few months due to time constraints but I would say I was about 90% there.
Post #679757
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse