batch file

[NIKHIL234656595]

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

Whats the meaning of this parameters in Sql batch file?

[NIKHIL234656595]

This example backs up the BUSINESS database using four data streams. Each data
stream uses two buffers.

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

Each data
stream uses two buffers.

What does this mean? Each data
stream uses two buffers.

[Marianne · Accepted solution]

All parameters are explained in NBU for SQL Admin Guide.

See http://www.symantec.com/docs/DOC3670

See p. 22 under the topic:
What factors affect the data transfer rate during a SQL Server backup or restore operation?

and 51 Performance factors

plus Keywords and values used in batch files on p 107.

[NIKHIL234656595]

MAXTRANSFERSIZE is the buffer size used by SQL Server for reading and writing
backup images.

What it means?

[NIKHIL234656595]

BLOCKSIZE is the incremental size that SQL Server uses for reading and
writing backup images.

Whats this means?

[Marianne]

Have you had a look at the 3 sections of the manual that I pointed out above?

You will find explanation, meaning, examples, EVERYTHING you need to know.

[NIKHIL234656595]

i extracted the above text from there only.

[Marianne]

Yes, extracted from one small section. Go look at all three topics. There is lots more that just the bits that you have copied.