Hello, in noticing our server's c drive size limit is much smaller than it's
other partitioned drive is it usually good to change the 'Database default
location' of the Data and Log files to a different drive like in this the
case the significantly larger drive partition in SQL 2005 Management Studio?
If yes then should the system databases (master, model, msdb, tempdb) all be
moved from the c drive to the larger drive and what should the recommended
folder be named for the new larger location?

Yes, it is a good idea to set the 'Database default location'. Although you
can always specify the location on a create, this is a good safety net.

Regarding moving databases to a new location, this is a link to the Books
Online topic:
http://msdn.microsoft.com/en-us/libr...8(SQL.90).aspx
Please note the cautions on not separating the master, distmdl, and
systemresource databases.

And a longer paper on moving databases using detach and attach is here:
http://support.microsoft.com/default...b;en-us;224071

RLF


"7777" <NoSpam (AT) NoSpam (DOT) com> wrote