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

Backup job spawning several processes

gsc_ghxgsc_ghx Posts: 73
edited May 9, 2008 12:27PM in SQL Backup Previous Versions
I have noticed that when I am running a backup using SQL Redgate (4.2) that i have several processes in the activity monitor of SSMS. Does the backup job spawn multi thread operations for backups?


Geri :?:


  • Options
    Eddie DEddie D Posts: 1,789 Rose Gold 5
    Thank you for your post into the Forum.

    Are you referring to the Job Activity Monitor? If the answer is yes, the Job Activity Monitor views the current activity of Microsoft SQL Server Agent Jobs. See the SQL Server Books On-line article:

    As Red Gate SQL Backup relies upon the SQL Server Agent to trigger scheduled SQL Backup tasks. I would expect the any scheduled backup job you have created using the SQL Backup GUI to be listed.

    If you perform a one off or ad hoc backup using the SQL Backup, Backup Wizard. Then this task should not be listed, as it does not become a SQL Server Agent job.

    I hope the above answers your question.


    Eddie Davis
    Product Support Engineer
    Red Gate Software Ltd
    e-mail: support@red-gate.com
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
Sign In or Register to comment.