Question

kccrga on Fri, 13 Jan 2017 04:48:13


Hi All,

Currently, all the system databases (master,model and msdb) are in the C drive. Tempdb have been moved to different drives.

Any suggestions?

Regards,

kccrga


-kccrga http://dbatrend.blogspot.com.au/


Sponsored



Replies

Shanky_621 on Fri, 13 Jan 2017 05:01:18


Hi All,

Currently, all the system databases (master,model and msdb) are in the C drive. Tempdb have been moved to different drives.

Any suggestions?

Regards,

kccrga


-kccrga http://dbatrend.blogspot.com.au/

Normally SQL Server installation and data files are preferred on non system drive but this is actually not a big issue. Your question is are you facing problem.

Now going ahead make sure database files and log files are on different drive (if possible)