Kind of depends on your DBA's [Wink] At a previous position, all of the DBA's
(Oracle, SQL and Informix) hated the idea of anything communicating with their
database that they had no control over (that and they were cheap).
We worked with the SQL DBA to make use of user directed backups. He
We don't use it either.
SQL admins setup the backups to go to disk - all are to occur at the same time
on all the servers
Then I have a policy to backup the SQL servers that kicks off at 2 am.
This gets the server Plus the backups to disk that occurred earlier in the
night.
Now the SQL admins