Hi,

Lets 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