Script to stage a database restore from a database backup, a differential backup, and a series of transaction backups
This example shows a script that you generate in the Restore Microsoft SQL Server Objects dialog box.
OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "DatabaseA" # The following image is type: Full NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.db.DatabaseA.~.7.001of001.20140701094227..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE DATABASE DUMPOPTION INCREMENTAL DATABASE "DatabaseA" # The following image is type: Full database differential NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.inc.DatabaseA.~.7.001of001.20140701103323..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseA" # The following image is type: transaction log NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseA.~.7.001of001.20140701090005..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseA" # The following image is type: transaction log NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseA.~.7.001of001.20140701100030..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseA" # The following image is type: transaction log NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseA.~.7.001of001.20140701110015..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 6 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE