<div>
When you create a database you should be able to specify where to store the database files.<br />
<br />
You can also change the default location:<br />
<br />
<a href="http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c16a591f-86cc-4ce2-94ef-c8ad34054de8" rel="ugc nofollow">http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c16a591f-86cc-4ce2-94ef-c8ad34054de8</a>
</div>


When you create a database you should be able to specify where to store the database files.

You can also change the default location:

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c16a591f-86cc-4ce2-94ef-c8ad34054de8 [http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c16a591f-86cc-4ce2-94ef-c8ad34054de8]

<div>
<div class="content wysiwyg-content">
Hello Everyone; <br />
<br />
I'm not really good at MS SQL, but I would like to install it on the C Drive and have all the database saved on the D Drive. <br />
<br />
is there any way we can do it ? I already have installed MS SQL on the C:\ dive so what i'm most interested in, is how to make the DB be saved completely on another disk partition (in our case D:\). <br />
<br />
Thanks &nbsp;
</div>
</div>


Hello Everyone; 

I'm not really good at MS SQL, but I would like to install it on the C Drive and have all the database saved on the D Drive. 

is there any way we can do it ? I already have installed MS SQL on the C:\ dive so what i'm most interested in, is how to make the DB be saved completely on another disk partition (in our case D:\). 

Thanks  

MS SQL Express How to make the Database on separate disk or separate partition

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.