Solved

Delete damaged instance - SQL server 2000

Posted on 2008-09-29
1
713 Views
Last Modified: 2012-05-05
Running SQL server 2000 Enterprise on HP ML150 server.
Installed one instance successfully.  The other instance (TESTSQL) failed to install correctly.  Event viewer said cd had a bad block.  Cannot uninstall TESTSQL. Message says log file is corrupt, uninstall will cease.  

I have tried to reinstall TESTSQL, machine tells me an instance with that name already exists.  I need that instance.  How do I fix this?

Urgent problem - 500 points
0
Comment
Question by:donpick
1 Comment
 
LVL 14

Accepted Solution

by:
Jagdish Devaku earned 500 total points
ID: 22602895
Hi,

You can do it by following the below steps:

Remove a specific instance of SQL Server
To remove a specific instance of SQL Server, follow these steps: 1. Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder where %drive% is the location of the instance of SQL Server you want to remove.
2. Locate, the following registry key: " HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

Note If you are deleting a default instance, you must delete all the keys EXCEPT the Client key.
" HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

You must use Regedt32.exe to edit the InstalledInstances value of the instance you are removing. A default instance is listed as MSSQLSERVER, and named instances appear as the name given to the instance.

Note You cannot use Regedit.exe to edit the value; you must use Regedt32.exe instead.
 
For more info, check the below link:

http://support.microsoft.com/kb/290991

All the best... let me know if you are facing any issues...
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now