GeorgeGR
Grasshopper
Points: 15
More actions
January 16, 2004 at 8:16 am
#161389
Hi,
Is there a generally accepted standard for installing SQL Server & the databases, referring to the placement of the data and log file(s)?
Rgds,
George
Sopheap Suy
SSCertifiable
Points: 7893
January 16, 2004 at 9:06 am
#490454
This is how we do this in our group:
SQL Program file can be on C:\ or it's own drive.
Data on it's on drive
Log on it's own drive.
backup on it's own drive.
mom
Steve Jones - SSC Editor
SSC Guru
Points: 728159
January 16, 2004 at 10:59 am
#490490
In general we do:
OS Drive: SQL OS + client tools (Raid 1)
Z: drive - Data + backups (Raid 5)
Y: drive - Log drives (RAID 1)
If we have a tempdb load, then the tempdb data usually gets its own drive. Backups potentially also get their own drives on some systems.
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply