<div>
<div class="content wysiwyg-content">
If I change the ldf files and mdf files of the database model.<br />
will all new databases automatically use the same directories that the model ldf files and mdf files use.<br />
<br />
example.<br />
model.mdf &nbsp; &nbsp; e:\SQLData<br />
model.mdf &nbsp; &nbsp; l:\SQLLogs<br />
<br />
all new databases unless otherwise specified will go to those locations?
</div>
</div>


If I change the ldf files and mdf files of the database model.
will all new databases automatically use the same directories that the model ldf files and mdf files use.

example.
model.mdf     e:\SQLData
model.mdf     l:\SQLLogs

all new databases unless otherwise specified will go to those locations?

Question about the Model Database and New Database Creation

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.