|
Posted by Simon Hayes on 07/08/05 19:42
"Brad" <bstumer@hotmail.com> wrote in message
news:1120829725.707986.65640@g49g2000cwa.googlegroups.com...
> Could someone please explain the pros/cons of installing the Veritas
> SQL agent versus backing up the .bak file generated by SQL Server? I
> have worked with both setups in the past, but never really understood
> what made one better than another.
>
> TIA,
> Brad
>
I've never used Veritas with MSSQL, but I imagine that if the Agent does
something which BACKUP/RESTORE can't do, or if your business has a backup
management infrastructure based on it, then it would be useful. On the other
hand, you probably can't restore any MSSQL backups without installing
Veritas on a server first, which could affect your disaster recovery plans.
Whatever backup software you use (or don't), the most important point is to
ensure you've tested and rehearsed different recovery scenarios
successfully.
Simon
[Back to original message]
|