One of my customer having problem with the transaction log backup .There is one maintenance job that will take Full backup on daily basis.and transaction log backup in 4 hrs.On Sunday there is one rebuild index job .After
this rebuild index job the transaction log is taking 17 minutes and it creates 12 gb transaction log backup (only for the first time). Usually the transaction took 6/8 seconds and the transaction file will be in less than 100 mb.
Pleas help me to resolve this issue
Thanks in advance
View Complete Post