Backup and Recovery Best Practices › Restore Overview › Checklists for Dependencies, by Type › Transaction Log Restore Dependency Checklist

Transaction Log Restore Dependency Checklist

A Transaction Log Restore restores and processes the Transaction Log contents, a process also known as "applying" or "replaying" the logs. Microsoft SQL Server re-executes the changes contained in the log and rolls back any transactions that were uncommitted when you backed up the Transaction Log. Applying Transaction Logs lets you recover as much of a database as possible, up to the time when the last Transaction Log backup was performed. The only uncommitted transaction that Microsoft SQL Server does not roll back is the Microsoft SQL Log Backup transaction, which is completed as part of the restore process instead. Transaction Log Restores can only be performed from Transaction Log Backups.

Note: If the last backup before a Transaction Log backup with Truncation was a Transaction Log backup, that session specifically is the only required prerequisite.