pros and cons of moving master and msdb dbs
Posted on 2006-06-05
What are the pro's and con's of moving the master/msdb dbs. I know how to move them but wonder if this is the best option.
A typical server has 3 disk sets (C:, D: and E:).
C: is internal ATA drives, hardware mirror.
D: is external and resides on EMC SAN (fibrechannel, RAID 5 etc).
E: is also on SAN.
All my SQL data files sit on D: and log files on E: What I what to know, should I place the master/msdb data file on D: and the master/msdb log files on E: like my user databases? The tempdb will remain on C: as well as the SQL install files. I figure if C: fails, u can rebuild SQL and attach the unchanged copies of master/msdb and user databases after fresh install using the correct procedures. I'll still backup master/msdb and copy off server and I think the chances of SAN failing are much less than internal ATA drives. I also feel if C: fails with the master/msdb in default locations, you loose both your data and log file in one.