SQL Server - Transaction Log Management
Just wanted to clarify if someone can please advise:
Let's say we have Transaction Log file which was initially set to 4GB, and
autogrowth set by increment of 10%. Now Transaction Log has grown to 40GB.
Question: Does transaction log backup will truncate the tlog once
completed, means then the tlog will be back to 4GB or 40GB (but now 36gb
is available for reuse)
Regards
No comments:
Post a Comment