Monday, March 26, 2012

Model and File Paths

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.
Kevin
I bet you created the database via EM. Take a look at CREATE DATABASE topic
in the BOL
"Kevin Antel" <kevina@.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.
>
|||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
|||That was it Steve, thanks! <right click> on EM and set it there. I queried
BOL but couldn't find anything about that setting.
Thanks again!
"Steve L" <steve_lawrenson@.tiscali.co.uk> wrote in message
news:1138104852.069486.319350@.g44g2000cwa.googlegr oups.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
>

No comments:

Post a Comment