Beginning Backup and Restore for SQL Server: Data Loss Management and Prevention Techniques

© Bradley Beard 2018

Bradley BeardBeginning Backup and Restore for SQL Serverhttps://doi.org/10.1007/978-1-4842-3456-3_3

3. Transaction Log Backups

Bradley Beard¹ 

(1)

Palm Bay, Florida, USA

 

In this chapter, we will be focusing on the different techniques behind backing up transaction logs. This is the last piece of the puzzle as far as a complete backup solution, which consists of full, differential, and transaction log backups. This particular piece is important because, without transaction log backups, there can be no point-in-time restorations. In fact, there can be no restorations beyond what was in the last differential backup, and any data committed to the database since the last differential backup will be permanently lost since this data ...