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 (500+) in one SQL instance.

Backup of this server fails with:

Error code: 1713
Module: 349
LineInfo: 0xE821934A13FC025F
Fields: {"$module":"ArsDbBackupProvider_vsa64_10170"}
Message: Failed to process the shadow copy operation.
------------------------
Error code: 33
Module: 7
LineInfo: 0xE24F93D0B8D8C99E
Fields: {"$module":"ArsDbBackupProvider_vsa64_10170"}
Message: Failed to create volume snapshot.
------------------------
Error code: 50295
Module: 16
LineInfo: 0x3FEC04E376B8A273
Fields: {"$module":"ArsDbBackupProvider_vsa64_10170"}
Message: All attempts to create a snapshot have failed. To troubleshoot VSS issues, download and run Acronis VSS Doctor available at https://www.acronis.com/personal/vss-diagnostic-free-tool/
------------------------
Error code: 50242
Module: 16
LineInfo: 0x3FEC04E376B8A1F4
Fields: {"$module":"ArsDbBackupProvider_vsa64_10170"}
Message: Failed to start creating the volume snapshot. To troubleshoot VSS issues, download and run Acronis VSS Doctor available at https://www.acronis.com/personal/vss-diagnostic-free-tool/
------------------------
Error code: 50281
Module: 16
LineInfo: 0x3FEC04E376B89DAF
Fields: {"$module":"ArsDbBackupProvider_vsa64_10170"}
Message: 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/personal/vss-diagnostic-free-tool/
------------------------
Error code: 65520
Module: 0
LineInfo: 0xBD28FDBD64EDB8FB
Fields: {"code":"2147754996","$module":"ArsDbBackupProvider_vsa64_10170"}
Message:

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.
5 + 14 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.