61513: Acronis Backup Cloud: backup of a large number of SQL databases fails with "VSS writer 'SqlServerWriter' has failed to process the snapshot"

use Google Translate

Applies to: 

Symptoms

You have an SQL server with a vast number of SQL databases (100+) in one SQL instance.

Backup of this server fails with: VSS writer 'SqlServerWriter' with class ID 'A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A' has failed to process the snapshot. To troubleshoot VSS issues, download and run Acronis VSS Doctor available at https://www.acronis.com/en-us/personal/vss-diagnostic-free-tool/

or

Too many databases (<quantity of databases>) of SQL Server instance 'MSSQLSERVER' are selected for backup.

Solution

1. Set for SQL instance Maximum worker threads to total number of databases * 2. For example, you have 500 databases. Then set Maximum worker threads to 1000.

Using SQL Server Management Studio

    1. In Object Explorer, right-click a server and select Properties.
    2. Click the Processors node.
    3. In the Maximum worker threads box, type or select 1000.

Using Transact-SQL

    1. Connect to the Database Engine.
    2. From the Standard bar, click New Query.
    3. Copy and paste the following command set into the query window and click Execute.
      USE AdventureWorks2012 ; 
      GO 
      EXEC sp_configure 'show advanced options', 1; 
      GO 
      RECONFIGURE ; 
      GO 
      EXEC sp_configure 'max worker threads', 1000 ; 
      GO 
      RECONFIGURE; 
      GO 

2. Restart SQL server instance.

Run backup again. Is should work fine now.

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.