Skip to main content

No SQL writers warning

Thread needs solution

Hello,

 

I'm backing up Windows Server 2012R2 domain controller with SQL sxpress 2014 running on it (physical machine).

During backup I get multiply warnings "There are no SQL writers", although final backup status is "Succeed with warnings".

VSS service is running.

What does it mean and why it happens?

Thank you in advance.

0 Users found this helpful

Hi Leots,

Can you verify SqlServerWriter is listed in "vssadmin list writers" ?

It can be caused when you have leading or trailing whitespaces in database names, you can check by running the query "select 'x' + name + 'x' from sys.databases", there shouldn't be any character between x and the database name, also please check if the "NT Service\SqlWriter" is in sysadmin role.

The SqlServerWriter is a component supplied by Microsoft and locks the database files when requested, so Acronis can backup the database files directly without using queries.

Hi, Rafael,

Thank you so much!

Indeed, SqlServerWriter was not listed among VSS writers.
Granting sysadmin role to NT Authority\SYSTEM solved the problem.

Thanks again,
Leonid.