What does the SQL Backup Agent do?

terrihawkinsterrihawkins Posts: 17
edited August 7, 2008 6:29AM in SQL Backup Previous Versions
Hi, I just updated from version 3.? to 5.3.... version 3 did not have a service running with it (at least not one I saw), and I was just wondering what it does in V5... is it for doing remote scheduling or something? Or is it just to do normal backups and restores?

thanks

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Terri,

    The SQL Backup Agent does pretty much everything, to be honest. In version 3, the extended stored procedure used to simply call sqlbackupc.exe. Now, the xp sends commands to the Agent via a Windows mutex and the service does all of the backup work. This approach makes the program more modular, secure, and reliable in the sense that much less of the work is done in the SQL Server process.
  • Thank you, that is most helpful!
Sign In or Register to comment.