"Kevin Antel" <kev***@cqlcorp.com> wrote in message
news:ezw0GVNIGHA.1836@TK2MSFTNGP11.phx.gbl...
>I thought that the file path of the model is what would be used, when
>creating a new database.  I moved the logfile to it's own drive, and it all
>works fine.  However, when I create a new DB, it still shows that the Log
>file goes to the same directory as my data file.
>
> Am I missing something?
>
> Can someone help me set my system, so newly created DB's are DEFAULT to:
>
> d:\mssql\data    = mdf files
> e:\mssql\logs    = ldf files
>
> Thanks.
>

"Steve L" <steve_lawren***@tiscali.co.uk> wrote in message
news:1138104852.069486.319350@g44g2000cwa.googlegroups.com...
> Hi Kevin
>
> this can be set up in two places - one during the installation - which
> you could go back to using the REBUILDM.EXE utility I think - or right
> click at the server level for you SQL Server in Enterprise manager and
> you can set it on a tab under there - you may have to restart SQL
> Server to force it in.
>
> Model DB is the basis on all future DB creations - ie if you need to
> set Collation on a particular column for future databases, you can set
> it here and it will apply on all new databases. Also, you can set the
> sizes on Model, so all future databases will have that property (ie
> Immediate 50Mb MDF file)
>
> Cheers
>
> Steve L
>