Hi,

Let’s suppose a server with 2 hark disks (C and D).
I will create a new database.
Where should I create my data, log and backup files?

C:\MSSQL\DATA
C:\MSSQL\LOG
D:\MSSQL\BACKUP

Or (because “C” is more used by OS than “D”)

D:\MSSQL\DATA
D:\MSSQL\LOG
C:\MSSQL\BACKUP

Or should I create log and data on separated disk?

C:\MSSQL\DATA
D:\MSSQL\LOG
D:\MSSQL\BACKUP

In the scenario above, if I lost the disk “D”, using only the C:\MSSQL\DATA,
can I recover my database?

Sorry my bad English and thanks for any suggestion.

Roberto Cota