<div>
Each database you create has associated database files.<br />
<br />
I assume you want to move existing databases to partition D as well as only create new databases on D?<br />
<br />
What about the database binary files? Do you want them to be moved to D also?<br />
<br />

</div>


Each database you create has associated database files.

I assume you want to move existing databases to partition D as well as only create new databases on D?

What about the database binary files? Do you want them to be moved to D also?



<div>
PS there is some version confusion here. In the 'free' versions of SQL Server there are:<br />
<br />
MSDE (version 8.0)<br />
SQL Express (version 9.0)<br />
<br />
Which one are you using?
</div>


PS there is some version confusion here. In the 'free' versions of SQL Server there are:

MSDE (version 8.0)
SQL Express (version 9.0)

Which one are you using?

<div>
Sorry, SQL Express 2005. &nbsp;<br />
<br />
And no, this is an install, not a migration.
</div>


Sorry, SQL Express 2005.  

And no, this is an install, not a migration.

<div>
Hi,<br />
<br />
As nmcdermaid said above, do you want to merely put the porduction databases on another partition or driver, or have the whole of SQL Express on another drive?<br />
<br />
Regards<br />
&nbsp; David<br />

</div>


Hi,

As nmcdermaid said above, do you want to merely put the porduction databases on another partition or driver, or have the whole of SQL Express on another drive?

Regards
  David


<div>
Prefer to have SQL Express in whole on another drive, but will settle for the DB on another drive.
</div>


Prefer to have SQL Express in whole on another drive, but will settle for the DB on another drive.

<div>
<div class="content wysiwyg-content">
I need a way to redirect MSDE2005 to another partition. &nbsp;Can you help me with this. &nbsp;Please give an example of a redirect to the D partition. &nbsp;Any other commonly usefull switches would be great tool
</div>
</div>


I need a way to redirect MSDE2005 to another partition.  Can you help me with this.  Please give an example of a redirect to the D partition.  Any other commonly usefull switches would be great tool

SQL 2005 MSDE Command Line Switches

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.