• Despite the complete vagueness of the questions, plus the fact it does not matter which order you move the system databases, I chose tempdb as needing addressed next mainly because the proper placement of this database will have the highest performance impact compared to the other system databases.

    Personally, I would not recommend moving the master database in SQL Server 2005 because if you do you need to move the mssqlsystemresource hidden system database and I've seen where this does not work and SQL Server will not start up. If you install SQL Server to the proper folders, you will not need to move the master database.

    Also the statement about the placement of model impacting tempdb is completely wrong... model has nothing to do with moving the tempdb. See Moving System Databases in BOL.

    The statement about MSDB having no bearing on the stability of the database engine is a bit misleading as well. Between model and MSDB, MSDB is used a lot more and generally it's location is much more important then the model database. Model does not completely impact the location of new databases since I can define the default folder locations independently of where model is located. Out of all the system database, the placement of model would be my least concern.

    Sorry, but this was not a good question and even worse answer. I really do not care about the points but rather someone new to SQL Server reading the question and answer and being mislead. :blink:

    David