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
· Share on Twitter

Comments

  • 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.
    · Share on Twitter
  • terrihawkinsterrihawkins Posts: 17
    Thank you, that is most helpful!
    · Share on Twitter
Sign In or Register to comment.