SQL server backup
Updated: 21 May 2010 | 4 comments
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.
discussion Filed Under:
Comments
You can do it by adding
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.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
if i m not wrong we use
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
STRIPES has a different meaning - it defines the number of 'streams' each database will be broken up into.
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows.
Handy NBU links
Chanels
The STRIPES are what the Chanels are for Oracle DB's.
Omar A Villa
Netbackup Expert
These are my personal views and not those of the company I work for
Would you like to reply?
Login or Register to post your comment.