Home Forums SQL Server 2008 SQL Server 2008 - General Placing data file , log file and temp file in 1 drive or separate drive ? RE: Placing data file , log file and temp file in 1 drive or separate drive ?

  • Jeff Moden - Sunday, November 11, 2018 5:21 PM

    Everyone says that they supposed to be on "separate drives".  If these things are on a SAN, you'll have a bunch of "logical drives" and there's absolutely no guarantee that the files will actually be on separate physical drives unless the SAN guy sets it up that way.  And I can tell you for sure that the SAN guy isn't going to dedicate a 650 GB drive to your paltry TempDB or other small drive requirement.

    Also, if the head-end of the SAN goes south for the winter, all the drives are dead so it wouldn't matter if they were on real live separate "spindles" or not.

    Backups are whole 'nuther story.  If you're storing backups on the same SAN as the actual data, you're making a HUGE mistake!

    Hi Jeff,
    Thanks for the response
    Do you mean it is ok to put all data file , log file and temp file in 1 drive ? as these things are on a SAN
    We put backup on different san