As part of my daily sql 2008 tasks I review the job history from last night's run. When the log File Viewer comes up I see
Initialize log #1
...
Initialize log #20
...
Initialize log #40
..
Initialize log #55
and it takes a long time for it to pull up a few hundred records (we only keep the last 2 days worth of tasks.) Why is the viewer retrieving so many log files? What can be done to trim that number?
TIA,
bd