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