Forum Discussion

alazanowski's avatar
alazanowski
Level 5
14 years ago

Netbackup - MSSQL to backup multiple instances .bch script?

I am trying to consolidate the amount of mssql policies and .bch scripts that i have. Out of curiosity, has anyone been able to put multiple instances into a single .bch file? I looked through the mss...
7.1.x and Earlier
Backup and Recovery
Best Practice
How to
NetBackup
  • alazanowski's avatar
    alazanowski
    14 years ago

    Figured out the issue with symantec; seems that there were "blank" lines underneath the .bch files that were on the systems. While not noticeable to us, apparently the programming language interprets these as <> and hiccuped on these commands. So when in doubt, open in notepad and try to clean out all the "additional" existing lines on the file.

    Even symantec was flabbergasted for awhile till they found that.

    Also, as a note, while the netbackup documentation says that the SQLHOST line is unnecessary, it should actually say "REQUIRES" removal. This was also an issue that symantec discovered with us.
alazanowski's avatar
alazanowski
Level 5
14 years ago

Of course i can create 2 templates, but then I have to create multiple policies that would have additional templates in each policy. This is not the design of netbackup, so i shouldn't have to do it this way.

Also, if i insert the sql instances manually, i have discovered that it only backs up the very last one listed.

OPERATION BACKUP
DATABASE $ALL
SQLHOST "clientserverhere"
SQLINSTANCE "default"
SQLINSTANCE "DEV01"
SQLINSTANCE "DEV02"
NBSERVER "masterserverhere"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE