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

Backup job spawning several processes

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 :?:
gsc_ghx
0

Comments

2 comments

Sort by
  • Eddie D
    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 D
    0
  • gsc_ghx
    Thanks
    gsc_ghx
    0

Add comment

Please sign in to leave a comment.