Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Delete damaged instance - SQL server 2000

Posted on 2008-09-29
1
Medium Priority
?
732 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

916 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