I am brand new with this so bear with me, we are using NetBackup 6.5 using the MS-SQL-Server policy to backup up 2 SQL 2000 Servers - all databases.
I want to backup the FULL databases, the script I am using:
OPERATION BACKUP
DATABASE $ALL
SQLHOST "SQLSERVER"
NBSERVER "TAPESERVER"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
POLICY SQLSVR-MSSQL
ENDOPER TRUE
I've also run this script -- same result
OPERATION BACKUP
DATABASE $ALL
SQLHOST "SQLSERVER"
NBSERVER "TAPESERVER"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY SQLSVR-MSSQL
NUMBUFS 2
ENDOPER TRUE
These databases aren't huge - maybe 50GB --- when I view the progress in Activity Monitor a child job is spawned backs up 2MB and closes to spawn another child job. Obviously I get 1000s of child jobs to back up each database server and this slows the job down considerably.
Is this normal operation? How can I get one child process to back up a 10GB slice or so? Outside of the clutter this just seems really slow.
What am I doing wrong? Please help!