X hits on this document

442 views

0 shares

0 downloads

0 comments

193 / 200

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

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

This is an example of a full database restore script generated by the Restore Microsoft SQL Server Objects dialog box.

OPERATION RESTORE OBJECTTYPE FILEGROUP DATABASE "DatabaseR" OBJECTNAME "PRIMARY"

  • #

    The following image is type: Filegroup

NBIMAGE "cadoo.MSSQL7.CADOO\SECOND.fg.DatabaseR.PRIMARY.7.001of001.20060701095634..C" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" BROWSECLIENT "CADOO" MAXTRANSFERSIZE 0 BLOCKSIZE 7 RESTOREOPTION REPLACE RECOVEREDSTATE NOTRECOVERED ENDOPER TRUE

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

OPERATION RESTORE OBJECTTYPE FILE DATABASE "DatabaseR" OBJECTNAME "DBR_FG1_File1" # 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 1 . 7 . 0 0 1 o f 0 0 1 . 2 0 0 6 0 7 0 1 1 0 0 8 2 4 . . SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "BOW" C "

193

Document info
Document views442
Page views442
Page last viewedMon Dec 05 04:59:07 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments