Installing SQL Server and databases

• GeorgeGR

  SSC Rookie

  Points: 25

  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

  More actions

  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: 736212

  More actions

  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.