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.