Hello:

I was told that it is a good practice to place the data and log files of
system databases on separate drives. When installing SQL 2005, however, I
cannot find the place to "tell" SQL to install these files to separate
drives. Where do I find this?

childofthe1980s

I am not sure you can do this at install time. You probably have to move
them afterwards. The biggest gain would be separating the tempdb log file
from the data files and that can be done with an alter database and a
restart. There isn't as much gain for the other system dbs.


--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"childofthe1980s" <childofthe1980s (AT) discussions (DOT) microsoft.com> wrote in
message news:7E524567-5D6D-4B24-A767-B5EE75306897 (AT) microsoft (DOT) com...