Skip to content

Latest commit

 

History

History
6 lines (5 loc) · 443 Bytes

README.md

File metadata and controls

6 lines (5 loc) · 443 Bytes

autofix-vlfs

Automatically fix high VLF counts in SQL Server 2012+ For more information how this works see: http://databasesuperhero.com/archive/2017/09/high-vlf-count-fix/

After creating the objects create a SQL Agent job. Step one will call procedure VLF_UpdateInfo. Step two will call VLF_AutoFix with the parameter @LogBackJobName parameter specifying your log back job so it can help mark the VLFs a the end the log file not active.