X hits on this document

477 views

0 shares

0 downloads

0 comments

183 / 200

Sample batch files Sample 3 - Perform a striped database backup. allow multiple internal buffers per stripe

Sample 3 - Perform a striped database backup. allow multiple internal buffers per stripe

This example backs up the BUSINESS database using 4 data streams. Each data stream uses 2 buffers.

OPERATION BACKUP DATABASE "BUSINESS" SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "CHISEL" STRIPES 4 NUMBUFS 2 MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE

Sample 4 - Restore a database from multiple stripes

For a striped restore, you must specify the number of stripes and the name of the first backup image name. Notice that the backup image in this example is embedded with the string .001of004, which indicates that it is the first of four backups.

OPERATION RESTORE OBJECTTYPE DATABASE DATABASE “Northwind” NBIMAGE cadoo.MSSQL7.CADOO.db.Northwind.~.0.001of004.20060216151937..C STRIPES 004 MAXTRANSFERSIZE 0 BLOCKSIZE 0 SQLHOST "CADOO" SQLINSTANCE "SECOND" NBSERVER "CHISEL" BROWSECLIENT "CADOO" RECOVEREDSTATE RECOVERED ENDOPER TRUE

183

Document info
Document views477
Page views477
Page last viewedTue Dec 06 20:38:52 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments