Forum Discussion

NIKHIL234656595's avatar
NIKHIL234656595
Level 6
14 years ago
Solved

batch file

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?

7.1.x and Earlier
Backup and Recovery
NetBackup
  • Marianne's avatar
    Marianne
    14 years ago

    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.

7 Replies

  • NIKHIL234656595's avatar
    NIKHIL234656595
    Level 6
    14 years ago

    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's avatar
    Marianne
    Level 6
    14 years ago

    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's avatar
    NIKHIL234656595
    Level 6
    14 years ago

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

     

    What it means?

  • NIKHIL234656595's avatar
    NIKHIL234656595
    Level 6
    14 years ago

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

     

    Whats this means?

  • Marianne's avatar
    Marianne
    Level 6
    14 years ago

    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.

  • Marianne's avatar
    Marianne
    Level 6
    14 years ago

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