Moving SQL Server Tools Installation to a New Drive

#1

A client installed SQL Server 2005 on his C drive. Unfortunately, the drive
has run out of space, primarily due to Windows and SQL Server.

I've already moved the tempdb and production databases to a new drive.

To move the tools, is it a matter of Add/Remove Programs to uninstall them
and then reinstalling them on the new drive?

I'll be moving master and other system databases when we can.

Thank you
--
Charles Allen, MVP

#2

Thank you
--
Charles Allen, MVP

"Ekrem Önsoy" wrote:

Quote:

Hi Charles,

To move the tools, is it a matter of Add/Remove Programs to uninstall them
and then reinstalling them on the new drive?

Yes, you can remove them using that way and reinstall to another drive.
Nevertheless, ensure that "Remove SQL Server 2005 instance components"
checkbox is NOT selected and only "Workstation Components" is selected from
the common components list.

Note:
Even if you changed the installation directory, some components still will
be installed to the drive C: (or whatever your system drive). Some
components of SQL Server are configurable (in terms of installation) and
some are fixed. I suggest you to see the following link:
http://msdn.microsoft.com/en-us/library/ms143547.aspx

--
Ekrem Önsoy

"Charles Allen" <callen (AT) nospam-bkd (DOT) com> wrote in message
news:8D957050-27C7-411C-9FAD-8D161EFB7402 (AT) microsoft (DOT) com...
A client installed SQL Server 2005 on his C drive. Unfortunately, the drive
has run out of space, primarily due to Windows and SQL Server.

I've already moved the tempdb and production databases to a new drive.

To move the tools, is it a matter of Add/Remove Programs to uninstall them
and then reinstalling them on the new drive?

I'll be moving master and other system databases when we can.

Thank you
--
Charles Allen, MVP

#3

Charles Allen (callen (AT) nospam-bkd (DOT) com) writes:

Quote:

A client installed SQL Server 2005 on his C drive. Unfortunately, the
drive has run out of space, primarily due to Windows and SQL Server.

Rather because it was too small from the beginning, I would suggest.

Quote:

I've already moved the tempdb and production databases to a new drive.

To move the tools, is it a matter of Add/Remove Programs to uninstall them
and then reinstalling them on the new drive?

To get any real effect out of this, you need to change ProgramFilesDir and
CommonFilesDir in the registry. Else most get installed on C anyway.

Note also that service pack installation for SQL 2005, also takes quite
some toll on C.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Moving SQL Server Tools Installation to a New Drive

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Moving SQL Server Tools Installation to a New Drive - 03-11-2009 , 10:35 AM

Re: Moving SQL Server Tools Installation to a New Drive - 03-11-2009 , 01:23 PM

Re: Moving SQL Server Tools Installation to a New Drive - 03-11-2009 , 05:07 PM