Restore Options
48 Agent for Microsoft SQL Server Guide
You must load backups of the Transaction log in the sequence in which they
were created. Microsoft SQL Server checks the timestamps on each backed
up database and each backed up Transaction log to verify that the sequence
is correct.
After Microsoft SQL Server has loaded the entire sequence of Transaction log
backups, the database is restored to its state at the time of the last
Transaction log backup, excluding any uncommitted transactions. The only
uncommitted transaction that Microsoft SQL Server does not roll back is the
Microsoft SQL Backup Log transaction, which is completed as part of the
restore process instead.
Note:
A Transaction Log restore must be applied to the original database or
to a restored copy of the original database. Otherwise, the logs will not be
applicable.
