-- and only if there's no active VLF at the tail of the transaction log file. -- Use this script when trying to reduce VLF count but without changing to SIMPLE recovery model -- and without attempting ...
declare @fltLogFilePercentageOfDataFile float = 0.25 -- set log file ratio - 0.2 = 20%, 0.25 = 25%, etc.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results