Home Forums SQL Server 7,2000 Administration How to reduce MDF data file? RE: How to reduce MDF data file?
MANU-J.
SSC-Dedicated
Points: 31126
More actions
January 1, 2009 at 5:02 am
#919933
Set target size to used space+Some breathing space. Yes, you can shring log file after that. Don't forget to do reindexing/defrag after shrink.
MJ