<div>
<a href="http://msdn.microsoft.com/en-us/library/aa933085(SQL.80).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/aa933085(SQL.80).aspx</a>
</div>


<div>
Lol, I thought so, but it seemed too easy a solution to me. Thanks again!
</div>


<div>
Alternatively...(to avoid bringing the db down for a long copy time)<br />
<br />
&gt;&nbsp;Create a new db with files on new drive using a full backup on current db. &nbsp;Name that db DB1_NEW<br />
&gt;&nbsp;Migrate all users from DB1 to DB1_NEW<br />
&gt;&nbsp;Rename DB1 to DB1_OLD and DB1_NEW to DB1<br />
&gt;&nbsp;Done (when you feel safe and finished testing drop DB1_OLD)....<br />
<br />
HTH
</div>


<div>
Thanks for the add'l info. Chapmandew's instructions did the trick.
</div>


<div>
&lt;&lt;Chapmandew's instructions did the trick.&gt;&gt;<br />
<br />
That's fine...sp_detachdb is a nice way to do it on regular db's...I wish I had the luxury of sp_detachdb on my 150Gb files and have my clients accept the file copy downtime ....
</div>


<div>
Yeah, my file wasn't quite that big. I just told my users to find something else to do for 30 minutes.<br />
<br />
Thanks again for all the feedback.
</div>


<div>
<div class="content wysiwyg-content">
Hello all.<br />
<br />
I'm looking for a way to move an .mdf to a larger volume. After a couple years, shrink isn't giving me any extra space. After running EXEC sp_spaceused, I see that there isn't any unallocated space left and it has gotten too big for the existing volume.<br />
<br />
Thanks in advance.<br />
<br />
Edit: Not sure why it says I'm a guru in this subject. Obviously I'm not :)
</div>
</div>


Hello all.

I'm looking for a way to move an .mdf to a larger volume. After a couple years, shrink isn't giving me any extra space. After running EXEC sp_spaceused, I see that there isn't any unallocated space left and it has gotten too big for the existing volume.

Thanks in advance.

Edit: Not sure why it says I'm a guru in this subject. Obviously I'm not :)

Move MDF to larger volume?

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.

Microsoft SQL Server

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.