Restore Overview
126 Agent for Microsoft SQL Server Guide
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.
Selected Session
Prerequisites
Post-requisites
Transaction Log
Backup
Any of the following:
■
The last prior Transaction Log
Backup
■
The last prior Transaction Log
with Truncation Backup
■
The last prior Database Backup
■
The last prior Partial Backup
■
Or, the selected session for
Partial, Files and FileGroups, or
Torn Page Restore
None, if selected as a Transaction Log
restore
The next Transaction Log Backup, if
included as part of a Files and FileGroups
or Torn Page Repair restore
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.
