Sample 5 - Restore a database transaction log up to a point in time

This script is executed after the database is restored. The database is restored to the specified point in time (Feb 16, 2006 at 2:03:00 P.M.). This time precedes the date of the backup log (Feb 16, 2006 at 2:03:21 P.M.).

Note the following:

If STOPAT is not specified, then the database is restored to the date of the backup log.
You do not need to manually stage the restoration of the database backup and the associated log files. Create the script in the Restore Microsoft SQL Server Objects dialog box.
Since RECOVEREDSTATE was not specified, the database is restored to a recovered state following successful execution of this script.

OPERATION RESTORE
OBJECTTYPE TRXLOG
STOPAT 20060216/14:03:00
DATABASE Northwind
NBIMAGE cadoo.MSSQL7.CADOO.trx.Northwind.~.0.001of001.20060216140321..C
MAXTRANSFERSIZE 0
BLOCKSIZE 0
SQLHOST "CADOO"
SQLINSTANCE "SECOND"
NBSERVER "CHISEL"
BROWSECLIENT "CADOO"
ENDOPER TRUE