Mid SQL

Transaction Log Backup (for databases that support it, like SQL Server):?

  • A transaction log backup records all the changes made to the database since

the last transaction log backup. It allows point-in-time recovery.

  • Advantages: Enables recovery of the database to any specific point in time

(assuming all previous logs are available).

  • Disadvantages: Requires continuous backups of transaction logs to maintain

full recovery.

  • Example: After a transaction log backup, you can restore to a specific

moment in time by replaying the logs up to that point.

More from SQL Server Tutorial

All questions for this course