Home Forums SQL Server 2008 SQL Server 2008 Administration How to reduce MDF file size ? RE: How to reduce MDF file size ?
dan-572483
SSCoach
Points: 15870
More actions
March 18, 2015 at 12:23 pm
#1784870
If you set the maximum size of the MDF file to it's current size, it will stop further growth and force new data to be written to the NDF on the other drive. Just be sure that the NDF is large enough to accommodate further expected growth.