X hits on this document

693 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 views693
Page views693
Page last viewedSun Jan 22 01:51:24 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments