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 ?

  • Putting all the files together on one drive invites a single point of failure disaster, so that's just plain wrong. Say they're all on the same drive, and the drive blows out. What do you do? If you had a backup and the log files, you'd just restore the old backup and then restore the transaction log, and the database would be brought current. If you have everything on the same drive, you can't do that.