User's Manual

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