MSSQL detaches the database

Many people may have done this before uninstalling the SQLSERVER database, but we need to note that sometimes it may not be completely uninstalled. Of course, unlike the ORACLE database, SQLSERVER can be re-installed if the uninstallation is not clean and may fail. How can I fully uninstall the database? The following operating environment uses WIN2008 + SQLSERVER2

Many people may have done this before uninstalling the SQL SERVER database, but we need to note that sometimes the database may not be fully detached. Of course, unlike the ORACLE database, SQL server can be re-installed if it is not uninstalled cleanly. It may fail to be installed. How can I fully uninstall the database? The following operating environment uses WIN2008 + SQL SERVER 2

Many people may have done this before uninstalling the SQL SERVER database, but we need to note that sometimes the database may not be fully detached. Of course, unlike the ORACLE database, SQL server can be re-installed if it is not uninstalled cleanly. It may fail to be installed. How can I fully uninstall the database? The following tutorial uses WIN2008 + SQL SERVER 2008 R2 as an example:

Step 1: Disable all SQL SERVER services.

Step 2: To start the uninstall process, click control panel from the Start menu, and then double-click programs and functions ". Select the SQL Server component to uninstall and click "Uninstall ".

Step 3: Start the SQL Server Installation Wizard and click the Remove button to start uninstalling SQL SERVER 2008.

Step 4: click Next. If there are multiple instances on the server, you can select the database instance to be detached from the drop-down list.

Step 5: select the component to uninstall. Generally, all are selected by default. In this way, you can delete all components.

Step 6: click Next.

Step 7: view the list of components and functions to be detached on the "prepare for uninstallation" page. The "installation progress" page displays the installation status. Click "close" on the "Finish installation" page to exit the installation wizard.

Step 8: delete successfully. Repeat Step 2-7 until all SQL Server 2008 components are deleted.

After performing the above steps, you need to check whether there are any SQL SERVER components that have not been deleted in the control panel, and then manually uninstall the following directories:

C: \ Program Files \ Microsoft SQL Server
C: \ Program Files (x86) \ Microsoft SQL Server

Then, clear the registry information.

(1) Delete the following registry subkeys:
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server

(In my operations, the following information is not displayed in the registry. It should have been cleared during uninstallation)

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServer

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLSERVER AGENT

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ services \ SQLBrowser

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ services \ MSSQLServerADHelper100

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ services \ MSSQLServerOLAPService

In SQL SERVER 2008, where the system is WIN7, we can also see the following registry information. If you see the existence of it, you must also clear the registry information.

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server 2005 Redist

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server 2008 Redist

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server Compact Edition

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server Native Client 10.0

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft Sync Framework

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft Sync Services

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft Sync Services ADO

(2) If Microsoft Search is installed, delete:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Search

(3) uninstall Microsoft full-text query (not required if it is not installed). You also need to delete the VM and Vm:
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSFTPSVC
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSCNTRS
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSEARCH
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSGATHERVER
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSGTHRSVC
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSINDEX