Hi Mike;

If you want to backup more than one / or all MSSQL db's you have two options:

1) A script containig the following:

--OPERATION BACKUP
--OBJECTTYPE DATABASE
--DATABASE $ALL
--MAXTRANSFERSIZE 0
--BLOCKSIZE 0
--DBMS MSSQL
--DSN "nbu"
--ENDOPER TRUE

where "nbu" is your ODBC user name and $ALL are all db's except tempdb

or

2)OPERATION BACKUP
OBJECTTYPE DATABASE
DATABASE "data1"
MAXTRANSFERSIZE 0
BLOCKSIZE 0
DBMS MSSQL
DSN "nbu"
ENDOPER TRUE

OPERATION BACKUP
OBJECTTYPE DATABASE
DATABASE "data2"
MAXTRANSFERSIZE 0
BLOCKSIZE 0
DBMS MSSQL
DSN "nbu"
ENDOPER TRUE


Here it just do a job for every single db name ...
Don't forget he file must be named xxxx.bch


Take care the way you configure your odbc user, .. ussually error 2 means that
was not possible to obtain the info from the .bch sript

Javier González
T4B Grup AG
www.t4b.ch

Michael Suen <suen AT cosmos.buffalo DOT edu> wrote:
> Hello All
> 
>       I am trying to setup the NBU MS-SQL Agent to backup Multiple
> Database at the sametime. According to Veritas Technote, I can use the
> BATCHSIZE X, parameter, but everytime I have that. The backup fail
> with error 2 on the "Nightlt_backup" Schedule and error 54 on the
> Default-policy?
> I am using NBU 3.4.1 (With Patch 3) and the MS-SQL 2K with win2K
> 
> Thank you very much for your help
> 
>               Mike
> 
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu