Suspicious Transaction Log.
Posted on 2006-06-07
Not really sure if this is a problem but it falls under the, 'I don't recall that looking like that', category.
One of the Transaction logs on one of my SQL2000(sp3) DB seems unusually large.
The db itself is, 3,000,000Kb but the accompanying Trans. Log is 54,000,000Kb.
I run a MaintPlan at 12 each night that utilizes all the tabs (Optimiziation, Backup Db, Backup Logs, etc.) then I use Veritas to come along around 3 and back up everything to tape.
Couple things are bothering me.
First, the size of the trans log. Second, the fact that neither the MaintPlan or the tape backup are flushing or compacting the trans log and third, the fact that I am starting to see various events and log entries making mention of the fact the the trans log backup failed due to disk space (have 35Gb free. surely that's enough).
Do I have a problem?