Istall package missing for component removal.

Question

Istall package missing for component removal.

neener

SSC Enthusiast

Points: 184
More actions
August 9, 2007 at 1:45 pm

#373146

Hi all, new guy with a question here. I am trying to remove an unused database from SQL Server 2005 SP2, but am halted. the installer asks me to browse for "sqlrun_sql.msi". When running msiinv.exe, it shows a path that no longer exists. And here is a funny thing;
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version      : Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Time            : Thu Aug 09 13:45:10 2007

SQL Server Setup was interrupted. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time            : Thu Aug 09 14:33:52 2007

Summary.txt gives me no error log, it only asks me to look in itself.
I have reached the end of the internet, looking for a solution. Does anyone have a resolution for this? Event log gives error code 1706.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 1

I must be missing something here, how/why are you dealing with msiinv.exe, etc. just to drop a database? Is this a visual studio setup (or other installer) package?

Joe

neener SSC Enthusiast Points: 184 More actions · Answer 2

I used msiinv to determine the original install path. This is a SQL Server 2005 install.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

I cannot see how a DROP DATABASE XXX statement would result in sql server trying to (un)install anything.

In any case, if the .msi is missing, did you ever delete stuff from the installer dir in windows subtree? I had to do this because my boot partition was filling up from all the sh-t dumped there (over 2GB of installer files!!) and now I can't upgrade numerous pieces of software, including sql server.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 4

Neener -

I'm still not sure why you're running set up to delete a databases - why not just delete the database via SSMS?

Joe

neener SSC Enthusiast Points: 184 More actions · Answer 5

The software is not trying to uninstall itself, I am trying to simply change the install and remove a database that is no longer in use.

What is SSMS? Could I use this to remove the database without affecting the other?

steve smith-401573 SSChampion Points: 10889 More actions · Answer 6

neener - it sounds like you are using faulty logic to achieve your ends. WHY would you use the install to remove a database that 'is no longer in use' is the question others are asking. My question is 'HOW do you know it is no longer in use?' Is it a system database or a true user database? What do you mean by 'remove'? Eliminate all the data files and indices? or all references to it, no matter where they may lie?

And, furthermore, what led you to believe that the database was created by the installer, in the first place?

neener SSC Enthusiast Points: 184 More actions · Answer 7

Sorry I am a server guy not a database guy. This database is no longer in use, I want to remove all references, tables, indexes, etc. So since I have been using the wrong method to remove, what should I do?

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 8

see my first post: DROP DATABASE databasename

connect to the server using the tool of your choice. sql server management studio is the main interface to sql 2005 and comes with the setup.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

neener SSC Enthusiast Points: 184 More actions · Answer 9

Tnx Guru, but I see no command line in the Management Studio. What am I missing here?

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 10

Management Studio is a GUI for connecting to database servers. There is a link to it in the Start Menu folder that was created when you installed SQL Server.

If you truly desire a command line environment, there is sqlcmd, which can be started from the Run section of the Start Menu.

May I STRONGLY recommend you attend an introductory training session on SQL Server 2005. Without this you will be essentially non-functional with the product.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 11

If you've managed to open SSMS and connect to your database server you should see a list of all the databases in the left hand tree view - to drop the database, simply find the correct database, right click, select delete... it will delete the database and all of the associated files from the disks.

Joe

Lowry Kozlowski SSCommitted Points: 1918 More actions · Answer 12

A very helpful tool in this is the help button in the tool bar. It allows for one to select "How do I" and then once it is open type in the question "Delete Database" and it will then tell you how to do it. Joe's answer is dead on. But I would add before I did that I would search for how to backup database and do that before messing around with a database delete. This will allow for recovery.

neener SSC Enthusiast Points: 184 More actions · Answer 13

You guys have been very helpful. The reason that I had issues with the advice in this thread is because this was (apparently) for SQL Server Express. Thanks for all your help, I have it resolved.