September 19, 2007 at 2:18 am
Hi Guys,
Last night the log shipping went out of sync on one of our databases. The logs that needed to be restored were about 1GB in size from 10:00PM to 15:00AM.
I asked the developers whether they did any huge transactions during those times. They replied by saying that they did nothing on the database during those times.
How do I go about investigating why these logs are so huge? Where do I start?
Regards
IC
September 20, 2007 at 7:07 am
Are there any batch jobs that run at that time?
September 20, 2007 at 7:14 am
There are jobs that run whole day. Every 5/10/20 min etc. I check some of the jobs but there does not seem to be anything out of the ordinary for eg, log running jobs
October 1, 2007 at 9:28 pm
It's not any long running jobs, it's more that if a lot of data changes occur, the logs grow. If someone updated every row to some wrong value and then updated it back, you'd have double the transactions.
If you want, you can download the Red Gate Log Rescue tool (it's being given away for free) and examine the logs. Look for what has changed and that will clue you in.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply