We have SQL Server 2000 running on Windows Server 2003. We've recently moved to new hardware. We use ArcServe / Brightstor for backups. On the old server we used the SQL agent. We also have agents for file system backups.
We only have one server. SQL Server is set to simple recovery model. The old system was doing weekly full ("Database") backups and daily Differentials to tape via the SQL agent.
This might be a silly question but I'm wondering what we really gain by using the SQL agent other than added complication and memory use.
We have plenty of disk space. Is it a reasonable strategy to backup to disk using the standard SQL Server backup functionality and then simply backup those files using the file system agent? One advantage I see of doing that is that it would give us precise control of the time when the SQL backup occurs. With ArcServe doing it, it happens in the queue which includes other servers on our LAN.
We soon plan to have a second server and implement log shipping.