SQL SERVER 2005 INSTALLATION

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL SERVER 2005 INSTALLATION

SQL SERVER 2005 INSTALLATION

Rate Topic

Display Mode

Topic Options

Author

Message

Sponge-592981

Posted Thursday, October 30, 2008 4:32 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

Team:

I currently work for a company that requires sql server and all applications to be installed on a separate drive (D:) not on C: drive. Well being new here I noticed that applications are sure enough installed here and there. SQL Server specifically installed on C: drives. I would like to adhere to this policy and move these sql servers from one drive to the other.

To my knowledge SQL SERVER 2000 installations do not place everything on the designated drive path and still places some files on c: whether you like it or not. I am not sure if this applies to sql server 2005.

What I would like to know is how to do it for both. I have been trying to search on the internet on www.yahoo.com and find pretty much "nothing much" :)

Please help:

ReshadIT@hotmail.com

Post #594710

Mohan Kumar

Posted Thursday, October 30, 2008 5:48 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336, Visits: 595

In 2005 also, C: drive will hold some binary files

--www.sqlvillage.com

Post #594729

Sponge-592981

Posted Saturday, November 01, 2008 2:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

Thanks for confirming. Any idea where I can get more details to this delima?

Post #595403

Elisabeth Rédei

Posted Saturday, November 01, 2008 11:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 5:56 AM
Points: 175, Visits: 676

Hi,

Do you mean that you have installed SQL Server on C:\ but you want to manually "move" it do D:\?

Basically, what you are asking for is ALL the steps (well, a lot of them anyway :P ) that the SQL Server setup does when you install SQL Server.

Well, I for one cannot provide them :)

Re-install is the only thing that springs to mind.

:)

/Elisabeth

elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei

Post #595468

Steve Jones - SSC Editor

Posted Sunday, November 02, 2008 7:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

Reinstall is all you can do. There are too many things touched in the registry, files, etc.

You can easily detach databases, uninstall, reinstall, and attach them again.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #595569

Sponge-592981

Posted Monday, November 03, 2008 3:03 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

Thank you all for your timley responses.

Post #596158

EdVassie

Posted Monday, November 10, 2008 5:11 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 2,636, Visits: 2,788

The Readme file for SQL Server 2005 says how much space will be used on the system drive, and how much will be used for the program files if you direct the install to another disk. The Readme files for the SP upgrades have similar information for the additional space they require. While a SP is being installed, you normally need about 0.5 GB work space on the system drive, and a further 0.6 GB space in the system /Temp folder.

It is likely that after 3 to 5 years of applying maintenance to SQL Server 2005 you will use about 2.5 GB on the system drive, and about 0.5 GB on the program file drive. You need to plan the size of your system drive to allow for this.

The values for SQL Server 2008 will be different, but do not expect them to be lower.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 4 June 2013: now over 24,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #599770

Sponge-592981

Posted Friday, November 14, 2008 4:41 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 11:41 AM
Points: 45, Visits: 173

I am so happy I came back to view my old posts.

Thank you for this great reference!

Post #603160

« Prev Topic | Next Topic »

Permissions