Hi,
We are using the SQL DB agent on approximate 20 SQL servers and it works
very nice. We have had some problems when the db admin is running
maintenance scripts on the DB where the backup software has had problems
accessing the db (explainable error).
The advantage of the agent is that you will be able to recover the
database "easy" to another server or another db-name. You will also have
the possibility to do transaction log backups compared to the "stop
\ start script" (and restores) from the gui.
Instead of using the bpstart\stop scripts you could always do a SQL backup
to a directory and the backup this one - the disadvantage here is that it
requires more diskspace, but you will have more control of the SQL server
than stopping \ starting it.
It's also not recommended to recover a SQL database from the "raw" data
files as this might cause problems (you didn't mention what version of SQL
you were running, but the newer the version the better "options" for
recover by file-only)
We also have a few servers where the "owner" is responsible for creating
the dump file of the SQL server and i do the backup of that file.
I would have gone for the bpstart\bpstop solution but a disk dump of the
databases and then a file backup of the dumpfiles. And as always should
this be documented :)
regards
Kim
On Wed, 18 Feb 2004 11:46:49 -0500, Charles R Somogyi
<charles.somogyi AT bms DOT com> wrote:
> Hello All:
>
> Does anybody have opinions on the NetBackup SQL DB agent for 4.5.
> We have several small SQL server DB's and are not sure if we
> should try to implement agent or simply use bpstarts and ends to
> start and stop SQL processes and backup up "hot" backups from the
> client's disk (the process we have been using for years). It has
> shown that many a time, the agents sound like a great idea but
> then when trying to implement, the overhead is realized and it is
> considered "just not worth it". Could anyone send on info
> regarding limitations, problems, etc, etc.
>
> (NB 4.5/ HP / STK / LTO2)
>
> Thanks.
>
> Charlie
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|