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?

Thanks

Geri :?:

Comments

  • Eddie DEddie D Posts: 1,780 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:
    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/11f2182c-5f71-46f8-8d2b-74f0fc48f2d6.htm

    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

    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
Sign In or Register to comment.