Viewing 4 posts - 1 through 4 (of 4 total)
Hi guys, the issue has been resolved. It is caused by the Rebuild Index that I schedule on 10PM while my transaction logs backup is every 2 hours from 8AM...
April 30, 2015 at 1:14 am
Ville-Pekka Vahteala (4/28/2015)
As said before this can be the reason.
Noted that, I try to disable the daily Rebuild Index today and see the result tomorrow.
runaldo (4/28/2015)
April 29, 2015 at 7:47 am
I forgot to mention that I had daily Rebuild Index on the Maintenance Plan. Is this cause the log file to grow?
April 28, 2015 at 8:38 pm
I did take transaction log backup, but the transaction log isn't decrease but increase. Please refer to the attached screenshots.
April 28, 2015 at 1:34 am
Viewing 4 posts - 1 through 4 (of 4 total)