Dear list, We had an engagement with the SeeFusion folks a few months ago (6?) in which they made some recommendations to us regarding a new SQL Server box. I'm not sure if our hosting company did what they recommended (I was not involved in that part of the engagement) but here's what we've got now.
The server has 4x146gb scsi drives set up in 2 RAID-1 mirrored sets. We ended up with a 20 gig C drive and a 120gb D: drive on one mirrored set, and 70 gig E: and F: drives on the other mirrored set. Currently we've got our SQL Server data files on the D: drive, the transaction logs on the E: drive, and the backups on the F: drive. The database is relatively small (7gb) but used pretty heavily.. I have the ability to add four more drives to the machine... I'm thinking of adding 4x73gb (15k rpm) in a RAID5 set with two partitions on it.. one maybe 50gb for the sql data files, and the rest for storing backups... then I will truly have my OS, data, and transaction logs all on separate drive sets. Seem reasonable? Other Suggestions? -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320341 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4