I have a weekly reindex job for all databases in maintence plan.
Sometimes it failed with the message transaction log is full.
We do have a transaction log back up before it 1 hour ago.
And now when I check it the transaction log is 99% free.
This because after the reindex, the hourly transaction log back up ran.
How can we avoid this problem of the reindex makes transaction log full?