April 11, 2005 at 12:27 pm
Good Afternoon,
Just a quick question, I use a nightly maintenance plan that performs a full database backup and then a transaction log backup. A second maintenance plan backup the transaction logs every two hours. My question is when do the transaction log file shrink . . .only after the full db backup, every T-log backup or never?
Thanks,
Pete
April 11, 2005 at 12:41 pm
Never, unless you check "remove free space" which I generally avoid for production databases...
When you backup the t-log it is truncated, but that doesn't mean that the physical file is shrunk. The transaction log file is actually divided up into virtual log files and when all the transactions within a virtual log file have been backed up (roughly speaking) that virtual file is marked as being truncated which means that it can be safely overwritten.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply