MDF Files growing huge.
Posted on 2006-07-18
I've tried just about every answer I've found here on E-E with no success.
Here's the statistics:
Under DATA FILES:
SQL 2000 Server Enterprise edition
Autogrowth is set to 10 percent.
Autoshrink is checked.
Auto update statistics is checked.
Auto create statistics is checked.
We have run DBCC SHRINKDATABASE('database', TRUNCATEONLY)
We have run DBCC SHRINKFILE
We have set a Maintenance Plan to shrink and truncate.
We have done all of this to no avail. The databases continue to grow huge. We have one that has 41% free and will not relenquish the empty space back to the OS. We shrunk it originally from 48 GB back down to 4.5 GB last week by exporting the actual data to another DB and today it measures at 8.6 GB. That is NOT good. Any help would be greatly appreciated.