Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL SERVER 2005 INSTALLATION Expand / Collapse
Author
Message
Posted Thursday, October 30, 2008 4:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
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
Posted Thursday, October 30, 2008 5:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, October 29, 2014 5:36 PM
Points: 1,339, Visits: 596
In 2005 also, C: drive will hold some binary files

--www.sqlvillage.com
Post #594729
Posted Saturday, November 1, 2008 2:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
Thanks for confirming. Any idea where I can get more details to this delima?
Post #595403
Posted Saturday, November 1, 2008 11:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 27, 2014 7:59 AM
Points: 177, Visits: 757
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
Posted Sunday, November 2, 2008 7:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:38 PM
Points: 31,355, Visits: 15,819
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
Posted Monday, November 3, 2008 3:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
Thank you all for your timley responses.
Post #596158
Posted Monday, November 10, 2008 5:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:03 AM
Points: 2,900, Visits: 3,298
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.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 18 October 2014: now over 31,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
Posted Friday, November 14, 2008 4:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
I am so happy I came back to view my old posts.

Thank you for this great reference!
Post #603160
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse