I know how to shrink the log files already, however, does anyone know how this can be done automatically, perhaps on a periodical basis?
Printable View
I know how to shrink the log files already, however, does anyone know how this can be done automatically, perhaps on a periodical basis?
You can set sql job for that, but not good practice to shrink log periodlically.
Why do you say that it's not good practice? How do I go about setting the SQL job to do this?
It'll grow again, so you get double performance hit. Better to control log with with proper log backup plan. If you really like to do, just run 'dbcc shrinkfile' as sql job.