If you have a full recoverymodel, is the T-log truncated when doing a full database backup? When you do a T-log backup? Or do you have to explicitly run a Truncate nly script?
It's truncated automatically and ONLY when you run a transaction log backup. Running a full backup does NOT truncate the transaction log, despite what you might see posted from time to time.
Student of SQL and Golf, Master of Neither
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply