April 12, 2016 at 8:54 am
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
May 15, 2024 at 1:02 pm
Still got this in SQL 2022.
Despite clearing log history right down the "Initialize Log" number initially climbs to 235, to then only return a handful of records.
No idea where all these log files are as there are only a couple on my server
No idea what 235 represents? maybe the number of restarts?
The files I can see are >
SQLAGENT.OUT & SQLAGENT.1 (located in E:\SQL_Data\MSSQL15.MSSQLSERVER\MSSQL\Log )
Any ideas folk?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy