Software Suite for Microsoft SQL Licenses User guide

3. To apply the transaction logs as well as to recover the database to the point in time desired,
enter the following restore commands at the command prompt:
a. Enter the following command for the first to the penultimate backed-up transaction logs
in the sequence:
RESTORE log database name from transaction log backup media with
norecovery;
The database is still in “no recovery” mode. You can now apply the backed-up transaction
logs to update the database to the point of failure.
b. Enter the following command for the last backed-up transaction log:
RESTORE log database name from transaction log backup media with
recovery; -stopat “timestamp"
For example:
RESTORE log northwind from Disk='G:\log1.bak' with norecovery;
RESTORE log northwind from Disk='G:\log2.bak' with norecovery;
RESTORE log northwind from Disk='G:\log3.bak' with recovery;
-stopat "Jun 28, 2006 5:44 PM"
Recovering All Data with Point-of-Failure Recovery 71