System Databases' Location 1

[fuzzyocelot]

My colleague and I have been researching this topic all afternoon and have become quite confused.

We're going to be migrating our development server soon to SQL Server 2005. The transaction level is fairly small on any given day. So performance isn't really an issue for us on this particular server. We're just trying to figure out if it's better to put the system databases on C with the installation or on a separate LUN. The user databases and logs will be on separate luns to mimic our new production server (which will be a cluster).

So other than for performance, manageability, or preference, are there any other good reasons why the system databases should or should not be put on a non-C drive/LUN?

Thanks!

 

[mrdenny]

Those are pretty much the reasons to not put the databases on the C drive.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[fuzzyocelot]

Thanks!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog