Home Forums SQL Server 2008 SQL Server 2008 Administration Doubts about dbcc shrinkfile working RE: Doubts about dbcc shrinkfile working
Lynn Pettis
SSC Guru
Points: 442467
More actions
August 23, 2013 at 12:23 pm
#1644529
Also, if your logfile grew to 100MB through normal operation you should leave it there. If you shrink it, SQL Server will just need to expand it again later when it needs more log space and can't reuse any of the VLFs in the logfile.