Question: How to manually delete the default instance, named instance, or virtual instance of SQL Server 2000
[Keyword ]:
Web SQL, server, 2000 How to manually delete SQL Server 2000 default instances, named instances, or virtual instances
This section describes how to reinstall SQL Server. Program System preparation.
The correct method for deleting Microsoft SQL Server 2000 (recommended by Microsoft) is to useUninstall. However, if the installation fails, it may not work.Uninstall. If you cannot useUninstallBefore you try to reinstall the SQL server program, you must restore the system to a clean and stable Installation Point.
Note:: Microsoft SQL Server 2000 (64-bit) Installer uses the Windows installer to fully integrate the installation of SQL server functionality into a function tree. The minimum and typical installation modes are no longer used. By default, the installer displays the function tree and selects all available features. The administrator can customize the installation by selecting a project in the function tree and changing the installation path. For more information, see the SQL Server 2000 (64-bit) documentation.
Considerations before deleting Microsoft SQL Server 2000
Important warning:You may want to save some databases in the current status. You may also want to save the changes made to the default database. If any of the above conditions is met, ensure that known data backup is retained before proceeding with the steps described in this article, or copy all data and log files to a folder other than the MSSQL folder, because you must delete the MSSQL folder in the following operations.
Files that must be saved include the following database files installed by Microsoft SQL Server 2000:
• |
distmdl. * |
• |
master. * |
• |
mastlog. * |
• |
model. * |
• |
modellog. * |
• |
msdbdata. * |
• |
msdblog. * |
• |
northwnd. * (optional) |
• |
pubs. * |
• |
pubs_log. * |
• |
tempdb. * |
• |
templog. * |
Warning: If the installed SQL Server is also used with Microsoft SQL Server reporting services, make sure that the following folders and subfolders are saved or renamed:
• |
Default path\ Reporting Services |
• |
Default path\ MSSQL \ Reporting Services |
• |
Default path\SQL Server Instance name\ Reporting Services |
• |
Default path\ 80 \ tools \ report designer |
Note::Default path% ProgramFiles % \ Microsoft SQL Server
Microsoft also recommends:
• |
For Microsoft SQL Server 2000 configured as a cluster system, ensure that no other cluster resources are dependent on Microsoft SQL Server 2000 to be deleted. For more information, clickArticleTo view the articles in the Microsoft Knowledge Base: 835185Http://support.microsoft.com/kb/835185)Resource dependency of failover clusters in SQL Server |
• |
Stop Microsoft SQL Server 2000 because an active connection may cause the uninstallation process to fail. |
• |
Close all Microsoft SQL Server 2000 clients or administrative tools on other nodes. |
• |
Use a Microsoft SQL Server 2000 Service account or an account with equivalent permissions (that is, a member account in the local administrator group) to log on to the server. If you configure SQL server as a cluster system, the account you use must be a member of the local Administrators Group on all cluster nodes. |
To delete an SQL server instance
Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of a problem. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Http://support.microsoft.com/kb/256986) Microsoft Windows Registry description
Warning: Improper use of the Registry Editor may cause serious problems and you may need to reinstall the operating system. Microsoft cannot guarantee that you can solve problems caused by improper use of the Registry Editor. You are at your own risk to use the Registry Editor.
Depending on your specific environment, you can take one or more of the following steps.
After the SQL Server is successfully deleted, you do not need to continue with the remaining steps in this list.
1. |
For a virtual server, use the Microsoft SQL Server 2000 installer on the installation disc and click the uninstall option. The "How to uninstall an existing installation of SQL Server (Setup)" (how to uninstall an existing SQL Server Installation (installer) topic in the SQL Server online manual describes this. |
2. |
For non-cluster (independent) instances, you can perform Step 1 or openAdd/delete programsSmall program. |
3. |
In the control panel, openAdd/delete programsSmall program. |
4. |
Run regedt32 and find the following registry key:HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Uninstall InUninstallTo delete the Microsoft SQL Server 2000 instance.Code. On the taskbar, clickStartAnd then clickRun. InRunIn the dialog box, copy and paste the following command, or enter the following command: C: \ winnt \ isuninst.exe-F "C: \ Program Files \ Microsoft SQL Server \ MSSQL $ server1 \ uninst. is "-c" C: \ Program Files \ Microsoft SQL Server \ MSSQL $ server1 \ sqlsun. DLL "-MSSQL. miff I = I1 If the above steps are invalid, you can followDelete all known instances of SQL ServerTo manually delete Microsoft SQL Server 2000. Note:: You do not need to delete SQL Server 2000 completely. Perform these steps to restore the system to the status where it can be successfully installed, so that you can delete the restored Microsoft SQL Server 2000 installation after the installation is complete. |
5. |
Find the installedDataFolder. To save the data, rename the folder. Otherwise, deleteDataFolder. Microsoft recommends that you retainDataFolder, which is equivalent to retaining the backup of the MDF and LDF format database flat files. If you renameDataFolder, as long as you use the same name, path, and IP address when re-installing, you can restore existing data to the same status and conditions as when taking SQL Server offline. |
Note:: If this is a cluster instance of SQL Server 2000, repeat these steps for each node in the cluster.
Delete a specific instance of SQL Server
To delete a specific instance of SQL Server, follow these steps:
1. |
Locate and delete% Drive %: \ Program Files \ Microsoft SQL Server \ MSSQL \ binn folder, where% Drive %Is the location of the SQL server instance to be deleted. |
2. |
Find the following registry key:
• |
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer Note:: To delete a default instance, you must deleteClient. |
• |
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server You must use regedt32.exe to editInstalledinstancesValue. The display name of the default instance is MSSQLServer, and the display name of the named instance is the name specified for the instance. Note:: You cannot use regedit.exe to edit this value. You must use regedt32.exe. |
|
Note:: If this is a cluster instance of SQL Server 2000, repeat these steps for each node in the cluster.
Delete all known instances of SQL Server
To delete all known instances of SQL Server, follow these steps:
1. |
Locate and delete% Drive %: \ Program Files \ Microsoft SQL Server \ MSSQL \ binn folder. |
2. |
Find and delete the following registry key:
• |
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ MSSQLServer |
• |
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server |
|
3. |
Find and delete the following registry key:
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServer |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLServerAgent |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServerADHelper |
|
4. |
The three registry items in step 3 correspond to the default instances of Microsoft SQL Server 2000. The registry key corresponding to the named instance is similar to the registry key listed in step 3,$ Instance_nameBecauseInstance_nameIs the name specified for a specific instance. Find the registry key corresponding to the instance to be deleted, and select and delete them.
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServer$ InstanceName |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLServerAgent$ InstanceName |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServerADHelper |
|
5. |
If the SQL server instance to be deleted is configured as a cluster system, delete all cluster resources of the instance in Cluster Manager. Note:: Only delete SQL Server resources. |
6. |
Reinstall Microsoft SQL Server 2000 and use the same name and IP address. |
7. |
Run the installer and useUninstallOption to eliminate any configuration issues or errors caused by installation failure. |
Note:: If this is a cluster instance of SQL Server 2000, repeat these steps for each node in the cluster.
Delete the default instance of SQL Server
To delete the default instance of SQL Server, locate and delete the following registry key:
• |
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ search |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServer |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLServerAgent |
Delete A named SQL server instance
To delete a named SQL server instance, follow these steps:
1. |
Find and delete the following registry key for a named instance. InstanceName is the name of the instance to be deleted.
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSQLServer $ InstanceName |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ SQLServerAgent $ InstanceName |
|
2. |
If the SQL server instance to be deleted is configured as a cluster system, delete all cluster resources of the SQL server instance in the Cluster Manager. note : Only SQL Server resources are deleted. |
3. |
reinstall Microsoft SQL Server 2000 and use the same name and IP address. |
4. |
run the installer and use the uninstall Option to eliminate any configuration problems or errors left over due to installation failure. |
Note:: If this is a cluster instance of SQL Server 2000, repeat these steps for each node in the cluster.
How to include full-text search and delete
To delete a full-text search, follow these steps:
1. |
Delete the following registry key. Only in use Delete all known instances of SQL Server The steps in this section should be used only when the steps in this Section are:
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ msscntrs |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ MSSEARCH |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ mssgatherer |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ mssgthrsvc |
• |
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ mssindex |
Note:: If you delete these registry items, Microsoft search is disabled ). If the following applications run on the same computer, this operation may affect them:
• |
Microsoft Exchange Server |
• |
Microsoft SharePoint Portal Server |
• |
Microsoft Site Server |
• |
Microsoft Commerce Server |
• |
Microsoft Small Business Server |
|
2. |
If the SQL server instance to be deleted is configured as a cluster system, delete all cluster resources of the SQL server instance in the Cluster Manager. Note:: Only delete SQL Server resources. |
3. |
Reinstall Microsoft SQL Server 2000 and use the same name and IP address. |
If MSSEARCH is not deleted, the following error message may occur when SQL Server 2000 is re-installed:
[Sqlclustersetup. cpp: 464]: 2 (0x2): The system cannot find the file specified. Problem in the Resource Name SQL Server Fulltext.
[Clushelp. cpp: 1238]: 5007 (0x138f): the cluster resource cocould not be found.
[Sqlclustersetup. cpp: 1059]: 5007 (0x138f): the cluster resource cocould not be found.
If the error message appears, restart the server, delete MSSEARCH, and try to install it again.
Note:: Because the deletion process has not been completed before, if you are worried about whether to delete the instance in the future, you can perform the following steps to verify if all the problems that may cause this problem to occur again. If you only want to confirm that the specific deletion has been completed, you do not need to perform this step because this step only checks whether the automatic deletion process is valid. Run the SQL Server installer and use the "Uninstall" option to immediately verify the deletion process, instead of waiting until this function is available. If this step fails, you must continue to check, identify the cause of the failure, and solve the problem.
Run the installer and then useUninstallOption to confirm that there are no configuration problems or errors left over due to deletion failure.
Note:: In some cases, folders may not be deleted.% Drive %: "\ Program Files \ Microsoft SQL Server \ 80, you must delete it manually.
When installing SQL Server 2000, the following error message may appear:
A previous program installation created pending file operations on the installation machine. You must restart the computer before running Setup
If this error message is displayed, restart the server and try to install it again. If the error message is displayed again after the server is restarted, the file to be deleted may be read-only.
Follow these steps to check whether these files are read-only:
1. |
Find the following registry key:HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Control \ Session Manager \ pendingfilerenameoperations |
2. |
Write down the file name. |
3. |
Make sure that no read-only attribute is set for these files. |
4. |
Restart the server again. |
Delete contents in the Temporary Folder before re-installing SQL Server
Delete all contents in the Temporary Folder. The temporary folder includes both the system temp folder and the temp folder of the installer. To determine the location of your Temporary Folder, enter the following command at the command prompt:
C: \ Documents ents and Settings \ USERNAME> set T
The result should contain the following:
Temp = c: \ w.e ~ 1 \ USERNAME \ locals ~ 1 \ temptmp = c: \ docume ~ 1 \ USERNAME \ locals ~ 1 \ Temp
Other items may be listed. The typical path is as follows:
C: \ Documents ents and Settings \ USERNAME \ Local Settings \ Temp
The typical path of system temp is % SystemRoot % \ Temp.
For more information, see the following article in the Microsoft Knowledge Base:
312995 Http://support.microsoft.com/kb/312995) SQL Server 2000 fails to be installed and the error message "... previous program installation..." is displayed.
The information in this article applies:
• |
Microsoft SQL Server 2000 Standard Edition |
From: http://www.ruanxun.com/HArticle56935.aspx