What are the challenges you face when working across database platforms? Take the survey

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?



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
  • Options
    Thank you, that is most helpful!
Sign In or Register to comment.