I have sql 2005 installed with sp2. I have an external file server with 1
terribyte of space. I want to have my data and log files on the external
file server. I mounted and mapped the external server at S:\Data and T:\Logs.
However when I try to create a db it only lets me use the local C: or D:
What do I need to do to get it to use the external drives?

Take a look at the KB article: http://support.microsoft.com/kb/304261

You basically need to enable a trace flag (T1807) to be able to create a
database. I'd stay away from any network mounted drive for any serious SQL
Server database.

Linchi

"john" wrote: