The Community Event for Data Recovery Experts
Watch for FREE to expand your cloud and security skills
On-demand event
- Veeam Support Knowledge Base
- SQL VSS Writer is missing: databases will be backed up in crash-consistent state and transaction log processing will be skipped
SQL VSS Writer is missing: databases will be backed up in crash-consistent state and transaction log processing will be skipped
| KB ID: | 2095 |
| Product: | Veeam Backup & Replication | 11 | 12 |
| Published: | 2016-02-10 |
| Last Modified: | 2021-10-05 |
| Languages: | FR |
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
Cheers for trusting us with the spot in your mailbox!
Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest
Challenge
Job reports warning:
SQL VSS Writer is missing: databases will be backed up in crash-consistent state and transaction log processing will be skipped
Running the command vssadmin list writers shows that 'SqlServerWriter' is not active.
Cause
There are different causes of the issue:
- the SQL instance has one or more databases with a name starting or ending in a space character.
- the account under which SQL VSS Writer service is running doesn't have sysadmin role on a SQL server
- SQL VSS Writer service stuck in an invalid state
This warning notifying that the "SQL VSS writer is missing" is a courtesy message that is presented to the user when Veeam Backup & Replication detects that the SQL VSS Writer is missing on a server where it was seen previously.
Solution
Below is a list of possible solutions that have been reported to us by customers from previous support cases.
Veeam is not responsible for any issues incurred after making the suggested changes. You are advised to contact and review all setting changes with the respective product support organization.
Veeam is not responsible for any issues incurred after making the suggested changes. You are advised to contact and review all setting changes with the respective product support organization.
Reported causes\solutions to fix the SQL VSS Writer not be present on a SQL Server:
- Use the "Repair" function within Apps & Features for the Microsoft VSS Writer for SQL Server
- To check if your database has a space in the name you can run the following query on the SQL Server which has the missing SQL VSS Writer. If you notice any spaces in the database names, then you will need to remove the spaces from the database names. (Changing database names may require checking with the software that is using that database to make sure it can be changed to the new name.)
select '#' + name + '#' from sys.databases where name like '% %'
The # shown in the SQL query results makes it easier to spot leading and trailing spaces.
- Make sure that the user specified in the [Log on as] for the SQL Server VSS Writer service is set as having a sysadmin role
- Restart SQL Server VSS Writer service
- In the case of SBS machines that are also Domain Controllers, ensure that the SQL Writer is running as a domain administrator and not local system
- Allow the SQL Writer service account access to the Volume Shadow Copy service via the registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\VSS\VssAccessControl
If the DWORD value “NT SERVICE\SQLWriter” is present in this key, it must be set to 1.
If the Volume Shadow Copy service is running, stop it after changing this registry value. Do not disable the Volume Shadow Copy service, it's default state is Manual.
More Information
More information about the SQL Writer Service is available here:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-writer-service
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-writer-service
To submit feedback regarding this article, please click this link: Send Article Feedback
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.
Spelling error in text
Thank you!
Your feedback has been received and will be reviewed.
Oops! Something went wrong.
Please try again later.
KB Feedback/Suggestion
This form is only for KB Feedback/Suggestions, if you need help with the software open a support case
Verify your email to continue your product download
We've sent a verification code to:
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Start using Veeam:
Download the product
&
Activate the license key
Thank you!
Your feedback has been received and will be reviewed.