April 23, 2009 at 7:23 am
Goodmorning,
I have a question regarding the size of a t-log backup after a full backup is done. Database size is 16GB, Full Backup compressed size is 2.8GB, T-logs are backed up every 20 minutes and average in size from 7Mb to 75Mb.
Full back is done Sundays at 2AM, the next T-log backup is at 3AM, the size of the 1st T-Logbackup after the full is 1.5GB. There is no major activity going on Sunday mornings.
Any idea why that 1st T-Log backup is so large?
We are using Sql-Backup V5, sql 2000.
Thanks,
Craig
April 23, 2009 at 7:31 am
If you reindex in a maintenance plan, which I think is a default for Sat night, it uses a lot of log space to rebuild the index. That is a logged operation.
April 23, 2009 at 7:58 am
Grab a log parser, look inside that log file. You can get a free trial for the ApexSQL one. I think RedGate has one that works for SQL 2000, too.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 23, 2009 at 9:05 am
Thanks for the responses. I will analyze the log.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply