Re: [Veritas-bu] MS SQL Agents
It entirely depends on your priorities.
If you can't afford the
cost of the agent, well, that's one way to do it. Although you better be
figuring in the total ownership cost of 3X the disk space of having your
live db and 2 backup copies online. That is not cheap either.
I've always heard the DBA argument
that we always want to have fast access to the disk for restores. I can't
rebut the argument that the disk is more highly available than the backup
system. However, I can say a SQL server backup to local disk, or restore
from local disk, using native SQLserver tools has never been as fast as
the NetBackup agent backup - that I have ever seen. Not that it is impossible,
but in my years I haven't seen it.
Also, if you have to go further
back for a restore than what you have on disk, it is going to take you
several times longer with more potential for errors - restore backup to
disk, then restore the db from the disk restore.
One more thing I'll say for the
NetBackup SQL agent (or Oracle too.) Once I have introduced DBA's to the
agent, demonstrated how the agent works, how the DBA's can now completely
manage their own backups and restores, they have never gone back.
I am currently looking
for info on backing up MS SQL boxes and wondered if the agent actually
does any type of snapshotting or are there scripts that have to pause the
database and then the backup begins? We currently have local scripts
in place that put the database in a mainteneance mode and copies data to
a data directory. Then the script starts up the database and our
Netbackup server comes in and does a regular backup of the box, which includes
the data directory. Why would I spend money for an agent when we
get backups with this method?
DTCC DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error, please notify us immediately and delete the email and any
attachments from your system. The recipient should check this email
and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted
by this email.
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu