ChiragNS (5/8/2012)
Will this increase the log file size or only the log backup size?
Just the log backup. The pages don't go anywhere near the log file itself, they're just copied into the log backup when it is taken.
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