Hello Jago

        Thanks for your help and informations.
        With the following scipt, it will backup the database
        one at a time.
        I would like to configure it to backup multiple database
        at the same time. According to technote 244559, 
        I should be able to do that with BATCHSIZE 3

        But, everytime I had BATCHSIZE 3 in my script, it fail  
        with error 2 and error 57. If I don't have BATCHSIZE 3, 
        the script works fine and it backup the database in sequency.

        Thanks for your help ....


                        Mike

On Tue, 28 May 2002, jago wrote:

> 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
> 
> 
>