X hits on this document

492 views

0 shares

0 downloads

0 comments

194 / 200

194

Sample batch files Sample 11 - Stage a database restore from a filegroup backup, several file backups, and transaction log backups

BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE

OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File2" # The following image is type: File NBIMAGE " c a d o o . M S S Q L 7 . C A D O O \ S E C O N D . f i l . D a t a b a s e R . D B R _ F G 1 _ F i l e 2 . 7 . 0 0 1 o f 0 0 1 . 2 0 0 6 0 7 0 1 1 0 0 9 0 8 . . SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE C "

OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File3" # The following image is type: File NBIMAGE " c a d o o . M S S Q L 7 . C A D O O \ S E C O N D . f i l . D a t a b a s e R . D B R _ F G 1 _ F i l e 3 . 7 . 0 0 1 o f 0 0 1 . 2 0 0 6 0 7 0 1 1 0 0 9 5 3 . . SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE C "

OPERATION RESTORE OBJECTTYPE TRXLOG DATABASE "DatabaseR"

  • #

    The following image is type: transaction log

NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.trx.DatabaseR.~.7.001of001.20060701100030..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7

Document info
Document views492
Page views492
Page last viewedWed Dec 07 18:25:39 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments