4514Shrinking MDF file
- May 5, 2010Hi,
I have a non-query database related question:
We have a database in SQL Server 2005 whose MDF file was increased to 300 GB. The system is used for reporting purposes only. We deleted somewhat 80% of the data through delete scripts but the file size of MDF didn't decreased. We were able to shrink the LDF file to a minimum (1MB), but the size for MDF is not decreasing by shrinking the database. Any suggestions?
[Non-text portions of this message have been removed]
- << Previous post in topic Next post in topic >>