<div>
<div class="content wysiwyg-content">
Hi, <br />
I have a question related to space on drives and size of mdf files. <br />
<br />
I have very little space left on one of my drives which holds some of my mdf files only (log files on another drive)<br />
<br />
Rather then shrinking the mdf to avoid fragmentation - I was wondering what options are best to approach. <br />
<br />
Currently the database has only one filegroup for the data file. <br />
Would it help to create another data file for the database on another drive? would this automatically start loading the data to this filegroup, and once the two mdf (data) files get to the same size, would they start sharing the loading?<br />
<br />
thank you,
</div>
</div>


Hi, 
I have a question related to space on drives and size of mdf files. 

I have very little space left on one of my drives which holds some of my mdf files only (log files on another drive)

Rather then shrinking the mdf to avoid fragmentation - I was wondering what options are best to approach. 

Currently the database has only one filegroup for the data file. 
Would it help to create another data file for the database on another drive? would this automatically start loading the data to this filegroup, and once the two mdf (data) files get to the same size, would they start sharing the loading?

thank you,

Shrinking mdf files

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.

Microsoft SQL Server 2005

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.