Fresh install of SQL 2005 done on drive with not enough space

[CathodeRay]

We have inherited a brand new SQL 2005 server on which the SQL may have been installed incorrectly. This is a fresh install, no databases.

Here are the symptoms, and then our questions:

1. SQL 2005 was installed on the C drive.
2. The capacity of the C drive is only 10gb, and there is only 1gb left.
3. SQL 2005 Management Studio is nowhere to be found.
4. We have gone into the SQL installation program to add the Client tools, but they, Integration Services and Notification Services appear to only want to be installed where the SQL Server was originally installed (on the C drive), and in this case, there is just not room.

Questions:

1. Is there a way to override the installation path for Client Tools, Integration Services and Notification Services?
2. Does it sound like we will just have to uninstall and reinstall SQL 2005 on a larger drive?
3. If we do uninstall and re-install, I suspect it will ask us for registration keys, correct? We do not have them, though we could get them without a lot of trouble.

There are no databases set up yet, so uninstalling won't hurt anything, but we would prefer to just move the engine or override a default installation path. Any ideas?

 

[Catadmin]

During installation, the paths can be changed, but I believe it's an all or nothing sort of thing. You can change the path of the total install, not part of it.

Do you really need everything installed? We had the same 10 GB problem with our installs and found if we didn't include Analysis Services, it saved us a TON of space. Since we're not doing data warehousing yet, we didn't have to worry about it.

Also, do an Alter Database on the system DBs to stick them on a different drive. That should save you a little space.

As far as the registration keys go, it depends on the software. Enterprise back end licensing (I'm sure that's not the proper name) tends to get CDs that install without asking for a reg key because the company has paid some un-godly amount of money for a lot of installs. You'd have to check with the people who originally installed it to find out if they had to use a Reg Key.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[CathodeRay]

Thanks for your reply.

We really just need Client Tools for now... but that will take up most of the 1gb we have left. (Sigh)

 

[Catadmin]

If you just need the Client Tools and the Server, dump all the other extras. Then you'll have plenty of space. Don't get the code goodies or sample DBs (AdventureWorks, etc.) and move the system DBs. Get rid of SRS, SSAS, SSIS, etc.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

I would go ahead and just uninstall the entire SQL 2005 package and reinstall it to another drive.

If you don't have another drive then this isn't a good machine to have SQL Server on anyway.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[CathodeRay]

Thanks all for your suggestions... We're going to move it to another drive....