Hi
I don't have the option 1.
Option 3 , I am already doing.
So I am left with option 2 only. Here also, the log size takes 2 hours to grow to 160 GB. So when log backups are happening every 20 min, then it shouldn't grow to that size, right?
John Mitchell-245523 (4/29/2013)
Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up. You have several options:(1) Allow more space for your transaction log
(2) Back up your log more frequently during index maintenance
(3) Use an index maintenance script that only rebuilds or reorganises indexes that are fragmented.
John
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.