Mark_Hill
18 years agoLevel 4
Generic SQL DB .bch file
Hey Guys, Im consolodating all the different SQL policies I have in my system.
Im looking at using this .bch file in a default location on each machine:
#*****************************************
#* SQL Backup Batch File *
#*****************************************
OPERATION BACKUP
DATABASE $ALL
MAXTRANSFERSIZE 0
BLOCKSIZE 0
ENDOPER TRUE
##########################################
But after running a couple of tests I get the strange result of the parent job failing with an error 2 and then the child jobs running on as usual.
Im running NBU 6.0mp4 and all the SQL DB's are M$ based.
Can anyone see anything wrong with the batch file, suggest improvements or see a better way of doing things?
Thanks in advance.
Im looking at using this .bch file in a default location on each machine:
#*****************************************
#* SQL Backup Batch File *
#*****************************************
OPERATION BACKUP
DATABASE $ALL
MAXTRANSFERSIZE 0
BLOCKSIZE 0
ENDOPER TRUE
##########################################
But after running a couple of tests I get the strange result of the parent job failing with an error 2 and then the child jobs running on as usual.
Im running NBU 6.0mp4 and all the SQL DB's are M$ based.
Can anyone see anything wrong with the batch file, suggest improvements or see a better way of doing things?
Thanks in advance.