We are here to help!

Find new ways to use Atera, Ask us anything.

Follow

0x800423f4

Depending on the configuration of a SQL Server, available threads can be used if you create a snapshot backup of many databases at the same time. Microsoft has an article referring to the issue and it's workaround:

  • If you are running a 64-bit version of SQL Server, you can consider increasing the Max Worker Threads configuration option.
  • If you are running a 32-bit version of SQL Server, please check the influence of increasing of Max Worker Threads to performance.

How to configure the Maximum Number of Worker Threads (SQL Server Management Studio):

***** In order to complete the backup successfully you will need to configure 5 Worker Threads for each sql instance, for example: if you have 10 sql instances  (databases) you will need to configure 50  Worker Threads in the Max Worker Threads option. *****
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request