Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ccaltacc
Starting Member
10 Posts |
 Posted - 2008-07-02 : 12:02:15
|
| Hello experts. I am installing SQL 2005. The PC has three hard drives C, D and E. My standard convention is to install the OS onto C, programs onto D and data onto E. I usually do this because the C drive is smaller and I would rather that any "growing programs" get put onto the larger drives.When I install SQL 2005 onto the D, it also puts files onto the C drive. This means that there are SQL 2005 files on all 3 drives (E is where the databases are going to be stored).Is this a good thing? If I install SQL 2005 onto C, will the program files folder grow even though the data resides on E? Also, are there any documented best practices covering this scenario?MANY THANKS!!! |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-02 : 13:14:42
|
| It will install the program Files and binaries on C:They wont Grow:Rest have everything else on E:\ and D:Data and Log File on Seprate Drives..with sufficient Space for Growth.This includes al your MSSSQL Data/Log Folder on D:\ and Log Files on E:I Hope you have Enough Space.Maninder |
 |
|
|
ccaltacc
Starting Member
10 Posts |
Posted - 2008-07-02 : 13:36:16
|
quote:
Originally posted by maninder
It will install the program Files and binaries on C:They wont Grow:Rest have everything else on E:\ and D:Data and Log File on Seprate Drives..with sufficient Space for Growth.This includes al your MSSSQL Data/Log Folder on D:\ and Log Files on E:I Hope you have Enough Space.Maninder
So you are suggesting that when installing SQL 2005, I DO NOT change the default install path to E instead of C. Leave the default path at C and store logs in E and Data in D ??THANKS! |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-02 : 13:55:24
|
| Yes you can take that approach, but again it depends.. if you dont have enough space.. Change the path to X:\ with Data Files.. and Logs on (Drive with most space)Maninder |
|
|
|
ccaltacc
Starting Member
10 Posts |
Posted - 2008-07-02 : 14:16:53
|
quote:
Originally posted by maninder
Yes you can take that approach, but again it depends.. if you dont have enough space.. Change the path to X:\ with Data Files.. and Logs on (Drive with most space)Maninder
Ok I got ya. So assume that all data and log files are going on the largest drive regardless of where SQL is installed. My question is, is there an actual benefit to changing the SQL install path away from the C drive to the E drive. Seems it would be easier just to leave it installed on C because it won't grow and just make sure the logs and data are on one of my larger drive? |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-02 : 14:21:25
|
| As far as i know.. No Benefit of moving the binaries around....Maninder |
|
|
|
|
|
|
Best practices for installing