Forum Discussion

rookie11's avatar
rookie11
Moderator
16 years ago

SQL server backup

Hi
we are backing up SQL server 2000 it has 40 databases, netbackup 6.0.Where in .BCH file i can make changes so that once the backup starts only 4 stripes starts.
  • You can do it by adding GROUPSIZE in the beginning of the .bch file.
    For more info, have a look at NBU for SQL admin guide.
    Extract:
    Keyword: GROUPSIZE
    Values: integer between 1 and 32
    Description: The number of databases that will be snapped as a single SQL Server backup image.

    You should be fine with a value of 10 for GROUPSIZE.
  • You can do it by adding GROUPSIZE in the beginning of the .bch file.
    For more info, have a look at NBU for SQL admin guide.
    Extract:
    Keyword: GROUPSIZE
    Values: integer between 1 and 32
    Description: The number of databases that will be snapped as a single SQL Server backup image.

    You should be fine with a value of 10 for GROUPSIZE.
  • if i m not wrong we use keyword STRIPES in the .bch file to start no. of concurrent backup from same client.

    like if we hav 40 databases in a single client n only this client in a policy then at a time only 4 databases wil be backedup.
  • STRIPES has a different meaning - it defines the number of 'streams' each database will be broken up into.