Home Forums SQL Server 7,2000 Administration How to reduce MDF data file? RE: How to reduce MDF data file?
thang_ngo_2002
SSCrazy
Points: 2187
More actions
January 1, 2009 at 4:19 am
#919926
As I understand, we need to run SHRINKFILE twice
- First with "NOTRUNCATE" to reallocate spaces
- Second with "TRUNCATEONLY" to reduce size
Is it correct?
And how to calculate "target_size" value of SHRINKFILE?
Thanks