60241: Acronis Backup: Backup of SQL instance fails with "There are no SQL writers" or "No SQL writers are found in the operating system."

use Google Translate

Symptoms

You have installed Acronis Backup Agent for SQL and created a backup plan for a SQL instance.

Backup task fails with this error: The backup of this SQL Server has failed because of a VSS snapshot failure: No SQL writers are found in the operating system

OR

Backup fails with:

The backup has failed because 'SqlServerWriter' has failed during snapshot creation.

And in Windows Application Event log, you notice this error from SQLWRITER:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0 Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3265
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0 Error message: The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.
 

Cause

Possible causes for this error issue include:

  • The SQL writer service is disabled
  • The SQL writer service fails to start correctly
  • The service account for the SQL writer service is missing the necessary privileges
  • Issue with SQL instance or database
  • There are spaces in database name

Troubleshooting

  The SQL Writer Service provides  added functionality for backup and restore of SQL Server through the Volume Shadow Copy Service framework, and its proper functioning is required in order for Acronis Backup to work:

1)  Hit Win+R and type services.msc. In Services window, find SQL Writer Service. If it is not started, right-click on it and select Start.

2) Make sure that SQL Writer Service runs under Local System account

3) If SQL Writer Service fails to start or crashes, investigate the issue with the service. Check the error message and Windows Application Event logs for possible causes of failure. 

4) Check that the user account is added to SQL Server security logins and that it has the "sysadmin" role for the SQL instance:

  1. Using SQL Management Studio, connect to the SQL instance.
  2. Go to Security -> Logins.
  3. Open account properties and switch to Server Roles:
  4. Mark the sysadmin check box:

5) On a domain controller, for example an SBS server, you might see that SqlServerWriter is not listed in the output of the vssadmin list writers command. In this case, change SQL VSS Writer Service user from Local System to domain administrator.

6) Check if there are spaces in database names:

  • Open MS SQL Management Studio, right-click on any database and select Run query 
  • Run the following query: select '#' + name +'#'  from sys.databases
  • If you notice any space in database names e.g. #database01  #, rename the database to exclude the space: see MS documentation for instructions.

More information

If the above solution does not help, use Acronis VSS Doctor for further troubleshooting.

For assistance, please contact Acronis Customer Central.

Tags: 

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