SQL Server 2008 install and disk space

Question

SQL Server 2008 install and disk space

Chrissy321

SSCoach

Points: 15763
More actions
April 29, 2011 at 8:10 am

#249906

Hello all,
I am installing SQL server 2008 on Windows Server 2008 R2. This will be a dedicated SQL server. My admin has set up the following drives.
C-(OS)-20GB
D-(apps)-10GB
E-(Data) 80GB
The C drive already seems tight with the OS install. 3.5 GBs free.
When I run the SQL setup additional disk space on C is consumed even though I select the D drive when possible during the installation.
My assumption was that I can install SQL Server completely on the D drive and not consume any disk space on C. Is this correct?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Geoff A SSChampion Points: 11511 More actions · Answer 1

yes. even though you choose to install on D:, a little bit of stuff still lands on C:. mostly shared components. small amount of data.

as a side note, 20 GB boot partition for windows 2008 R2 is way to small. after about 1 - 2 years, with OS updates coming down from Microsoft, logging and such, that 20 GB will be gone.

it should be at least 40 GB. imho

calvo SSChampion Points: 12930 More actions · Answer 2

yeah, always some junk on the local drive.

As Geoff said, plan for growth of the C: drive due to patches for the OS, SQL Shared features, and even other things like virus definitions and admin files. 20GB is real small for a local drive, go with 40GB or 60GB.

______________________________________________________________________________________________
Forum posting etiquette.[/url] Get your answers faster.

Chrissy321 SSCoach Points: 15763 More actions · Answer 3

Thanks, this is what I call actionable intelligence. Its a vm system so hopefully may admin can easily bump it up...

Geoff A SSChampion Points: 11511 More actions · Answer 4

it requires down time. do it now.

http://walter.thyselius.org/data/howto/vmware-expand-windows-disk.html

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 5

Common files are installed on disk where windows installed in the program files

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

My Blog
www.aureus-salah.com

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Even though you select any other drive say D for install, some common files for SQL Server will always be installed on C drive no matter what.

Thank You,

Best Regards,

SQLBuddy.