https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyOTExIiwiaGFzaCI6ImExNDkwZGMxLWJiOWItNDYyZC1hYmJiLTZiY2RmM2NhYmM1MyJ9
1-800-691-1991 | 9am - 8pm ET
EN

SQL VSS writer fails for SQL localdb on Azure AD Connect Sync server.

Challenge

Backup or replication jobs with Application Aware Image-Processing enabled may fail on the server hosting Azure AD Connect Sync with an error indicating the SQL writer has failed. After the job has failed, running “Vssadmin list writers” from an administrative command prompt on the Azure AD Connect Sync server shows the sql writer in failed state. In Hyper-V, the error in the statistics window in VBR may be “guest processing skipped” or may indicate that the checkpoint has failed. In Vmware, the error is usually “Backup job failed. Cannot create a shadow copy of the volumes containing writer's data. A VSS critical writer has failed. Writer name: [SqlServerWriter]

Cause

Updates to Azure AD Connect Sync will sometimes leave the server in a state where VSS snapshots will cause the SQL Server writer to fail.

Solution

After installing service pack 4 for sql localdb 2012 and rebooting the server (https://www.microsoft.com/en-us/download/confirmation.aspx?id=56040), the jobs will generally be able to run successfully. In some instances, the error may return after future updates to the Azure AD Connect Sync Client, in which case another reboot will resolve the issue. Microsoft has been made aware of the issue and future updates to Azure AD Connect Sync may either not cause this problem or should prompt the user for reboot. If a future update to the Azure AD Connect Sync client does not prompt for a reboot, you can either reboot proactively after updating to prevent this issue from happening or test the job and reboot if it fails following the update.
KB ID:
2911
Product:
Veeam Backup & Replication
Version:
Any
Published:
2019-03-13
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later