X hits on this document

698 views

0 shares

0 downloads

0 comments

191 / 200

Sample batch files Sample 10 - Stage a database restore from a database backup, a differential backup, and a series of transaction backups

Sample 10 - Stage a database restore from a database backup, a differential backup, and a series of transaction backups

This is an example of a script generated by 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.20060701094227..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 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.20060701103323..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 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.20060701090005..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7

191

Document info
Document views698
Page views698
Page last viewedSun Jan 22 06:28:51 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments