InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 00:40:44 GMT20http://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspxThanksSun, 23 Sep 2012 23:12:58 GMT- Winhttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspx[quote][b]EdVassie (9/21/2012)[/b][hr]There are no performance or integrity advantages in moving the locations of Master, Model, and MSSystemResource databases.If you make heavy use of msdb then consider moving its files to where you store your user databases, otherwise leave that alone also.Leaving these files in their original locations may look 'untidy', but many people run into problems when trying to move them. Also, Microsoft have a poor track record of making SPs and CUs work when these files are moved, but SQL 2008 R2 onwards (so far!) has been OK. A DBA should have more important things to do than put their system at risk doing work that gives no advantages.[/quote]Thanks for the advice - this is why I like to research something before I change it...Fri, 21 Sep 2012 07:34:10 GMTSkyBoxhttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspxThere are no performance or integrity advantages in moving the locations of Master, Model, and MSSystemResource databases.If you make heavy use of msdb then consider moving its files to where you store your user databases, otherwise leave that alone also.Leaving these files in their original locations may look 'untidy', but many people run into problems when trying to move them. Also, Microsoft have a poor track record of making SPs and CUs work when these files are moved, but SQL 2008 R2 onwards (so far!) has been OK. A DBA should have more important things to do than put their system at risk doing work that gives no advantages.Fri, 21 Sep 2012 06:47:58 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspx[quote][b]John Mitchell-245523 (9/20/2012)[/b][hr][quote][b]SkyBox (9/18/2012)[/b][hr]Everything restarted and moved ok. Is there anything I am missing or any "gotcha's" with this move? Will this affect upgrades or service packs?[/quote]then I would recommend moving them to a drive dedicated to database files. John[/quote]My sys database files are properly located on my data file drive (not C:). It's my system database transaction log files that also reside on that data drive rather than the dedicated log drive.The only reason I started the post is because one reads/writes sequentially and the other randomly, but there's not much activity that I can see on those sys log files so it shouldn't be affecting the data drives performance.Thu, 20 Sep 2012 15:33:42 GMTSkyBoxhttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspx[quote][b]SkyBox (9/18/2012)[/b][hr]Everything restarted and moved ok. Is there anything I am missing or any "gotcha's" with this move? Will this affect upgrades or service packs?[/quote]No, it won't affect anything like that. If your system databases data files are on your system drive (for example in C:\Program Files\Microsoft SQL Server\....) then I would recommend moving them to a drive dedicated to database files. This ensures that SQL Server doesn't get choked by growth of things like application logs, and conversely that any growth of your system databases won't eat up all the disk space that the operating system should be using. You may find that your msdb database grows quite large, especially if you don't control your job, backup and maintenance plan histories.JohnThu, 20 Sep 2012 07:03:59 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspx[quote][b]Perry Whittle (9/18/2012)[/b][hr]There's little point moving the masters log file. Best to always keep the master files in one location as with model and msdb too[/quote]I'm not really seeing any activity on those log files, so I'll follow your advice.Thu, 20 Sep 2012 06:43:30 GMTSkyBoxhttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspxThere's little point moving the masters log file. Best to always keep the master files in one location as with model and msdb tooTue, 18 Sep 2012 21:40:38 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1361010-1550-1.aspxI normally leave sys db's in the default location (not tempdb). However, I have a production 2008 instance, where the sys db log files (.LDF's) reside on my data file drive/LUN.When testing on a SQL 2012 box I was able to alter/modify the files and move them fine with the exception of the master.ldf file. I had to change the path on the startup params w/in SQL config manager.Everything restarted and moved ok. Is there anything I am missing or any "gotcha's" with this move? Will this affect upgrades or service packs?ThanksTue, 18 Sep 2012 14:00:07 GMTSkyBox