Also, think about backing up the files to disk first (using SQL's internal
backup utility/wizard).  Then you should always be able to get a clean
backup of those files, which is better than nothing at all ;)

----- Original Message ----- 
From: "Dave Cecchino" <cecchind AT qwestip DOT net>
To: "Arif Budiman" <ArifB AT excelcom.co DOT id>
Cc: <veritas-bu AT mailman.eng.auburn DOT edu>
Sent: Monday, May 10, 2004 7:41 AM
Subject: Re: [Veritas-bu] Backing up MSSQL Server


> I've always seen that if you are running the netbackup service as local
> account it doesn't work that well, make sure you start the netbackup
> service as a real user account, example create a user called netbackup
> with admin permission.
>
> Also check the bphdb logs , dbclient, and dbbackup logs normally point to
> the error, and bump up the verbose. Make sure you change thelogin as a
> normal account rather than system account.
>
>
> On Mon, 10 May 2004, Arif Budiman wrote:
>
> > Dear guys,
> >
> > I'm trying to perform an MSSQL backup, but it always fails with status 2
> > (it means none of the requested files were backed up). If I run the
> > backup from client (user backup mode) it's succssfully completed. FYI, I
> > already created DSN for the database to be backed up.
> > Does anyone have suggestion ?
> >
> > Regards,
> > Arif Budiman
> > NOC - Backup Administrator
> >
> > _______________________________________________
> > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
>
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>