• 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.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara