How do I uninstall the SQL server database manually

Publication Date:  2016-11-21 Views:  383 Downloads:  0
Issue Description
How do I uninstall the SQL server database manually?
Solution
1. Uninstall the SQL Server database.
a. Choose Start > Control Panel > Programs and Features. The All Control Panel Items page is displayed.
NOTE:
If Programs and Features is not displayed in Control Panel, click Programs.
b. Right-click Microsoft SQL Server 2012 R2(64-bit), and choose Uninstall/Change.
NOTE:
If the computer fails to be restarted during the uninstallation, refer to 3 to delete the key value PendingFileRenameOperations.
c. Uninstall Microsoft SQL Server 2012 R2 (64-bit) as prompted.
d. Right-click the blank area on the All Control Panel Items page, and choose Refresh. Then right-click the other SQL Server programs and choose Uninstall.
e. Delete the MSSQL2012, MSSQL2012X, and MSDATA folders from the SQL Server database installation directory.
f. Delete the Microsoft SQL Server folder from Program files in the operating system installation directory.
g. Delete the Microsoft SQL Server and Microsoft SQL Server Compact Edition folders from Program files (x86) in the operating system installation directory.
h. Choose Start > All Programs, and verify that the Microsoft SQL Server 2012 program has been deleted. If it still exists, right-click Microsoft SQL Server 2012, and choose Delete.
i. Choose Start > Run, enter regedit in the Open combo box, and press Enter. Delete the following registry information in the Registry Editor:
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2012 Redist
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLSERVER
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\SQLSERVERAGENT
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerADHelper
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerADHelper100
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSDTC
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\setup.exe\RunAsOnNonAdminInstall
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\setup.exe\BlockOnTSNonInstallMode

2. Restart the operating system.

3. Verify that the key value PendingFileRenameOperations does not exist in the registry.
a. Choose Start > Run, enter regedit in the Open combo box, and press Enter. The Registry Editor starts.
b. Choose Edit > Find, enter PendingFileRenameOperations, and click Find Next.
c. Verify that the key value PendingFileRenameOperations does not exist. If the key value still exists, right-click it, and choose Delete.

END