SQL server backup

[rookie11]

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.

[Marianne · Accepted solution]

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.

[rookie11]

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.

[Marianne]

STRIPES has a different meaning - it defines the number of 'streams' each database will be broken up into.

[Omar_Villa]

The STRIPES are what the Chanels are for Oracle DB's.