Press "Enter" to skip to content

Transaction Logs During Full Backups

Erik Darling looks at what happens to transaction log backups while a full backup is running:


Unless you’re on SQL 2000, don’t worry about scheduling log backups during full backups
Log backups during full backups won’t truncate the transaction log
You want to keep taking log backups in case your full backup fails

Read the whole thing.