본문 바로가기

Computer/Database

How to uninstall properly SQL Server 2008 ?

Hello !

I want to uninstall properly SQL Server 2008 with a command line

Is there a good documentation on how to uninstall it without forget things (before / after) ?

There are a lot of remaining folder, components, registry key .....


Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

 

 

 

 

Hi,


To uninstall SQL Server 2008, try the following steps:
1. Make sure you have administrative rights on the computer
2. Uninstall the existing SQL Server 2008 and all the components from the control panel. Remember to backup the user databases before uninstalling SQL Server.
3. Backup the registry.
4. Delete the following keys in regedit:
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
5.  Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall  and delete all the sub-keys referencing SQL Server.
6.  Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services and delete all the keys referencing SQL Server.
7.  Rename or remove all the SQL Server folders in the computer.
8.  Download and install Windows Cleanup Utility:
http://support.microsoft.com/?id=290301
Run the utility and remove any SQL Server components that you find.
9. Reboot the machine.

If there are any more problems, please let me know.
Thanks.


***Xiao Min Tan***Microsoft Online Community***

 

 

 

출처 - http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3974daa9-9da1-46d9-8001-57b8517d3470?prof=required