How can we help you today? How can we help you today?

SQL Agent Necessary?

This is probably a novice question, however, I was unsure once SQL Backup was installed and the Backup Agent is successfully running, is there still a need to have SQL Agent running at all?
acorcoran
0

Comments

4 comments

Sort by
  • James Moore
    Hi Acorcoran,

    There is no need to have the SQL Agent running for a backup to run successfullly however the GUI scripts scheduled backups as SQL Agent jobs so if the SQL Agent is not running then any backup's you have scheduled will also not run.

    - James
    James Moore
    0
  • acorcoran
    So just to make sure I am understanding clearly, if we used the maintenance plan wizard in the past for optimization, integrity, we'll have to continue using the SQL Agent to run these? I know SQL Backup Agent will handle the backups of both database and transaction logs, but wasn't sure if it would also handle running the various maintenance tools inherent in enterprise manager?

    Thanks,
    Aaron
    acorcoran
    0
  • James Moore
    Hi,

    Yep you are right, SQL Backup will handle the backup's but it is left to the SQL Agent to continue doing the scheduling so for your maintaince plans to work (and your scheduled backups to run) you will need to keep the SQL Agent running.

    - James
    James Moore
    0
  • acorcoran
    Great,

    Thanks for the prompt responses and clarification.

    Aaron
    acorcoran
    0

Add comment

Please sign in to leave a comment.