Script to 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, 2014 at 2:03:00 P.M.). This time precedes the date of the backup log (Feb 16, 2014 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 20140216/14:03:00 DATABASE Northwind NBIMAGE "cadoo.MSSQL7.CADOO.trx.Northwind.~.0.001of001.20140216140321..C" MAXTRANSFERSIZE 6 BLOCKSIZE 7 SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "CHISEL" BROWSECLIENT "CADOO" ENDOPER TRUE