S_Kumar_S (4/29/2013)
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?
If you're rebuilding a 100+GB index during those two hours then yes, it should grow to that size. For index maintenance you need space in the log > total size of the largest index you're rebuilding.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability