System databases files location

Hi,

I have C,D,E drives on server. Data files will be on D and Log on E. My question is what is best practice for data and log files for system databases during sql server installation selection? Should they be on C drive along with SQL Server installation or D & E? If they should not be on C then what is the reason and what is benefit to move them on other drives. I just want to know what is best practice.

Thanks

May 16th, 2015 1:20am

You can put the log and data files for the system databases on the same physical drive...

I would not place a system databases on the system drive, (if the OS crashed you lose the entire instance) , but create a another physical drive for them.,...

And do not forget to backup system databases.

Free Windows Admin Tool Kit Click here and download it now
May 16th, 2015 2:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics