HP Application Software Suite for Microsoft SQL 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