1-800-691-1991 | 9am - 8pm ET
EN

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

KB ID: 2911
Product: Veeam Backup & Replication
Version: Any
Published: 2019-03-13
Last Modified: 2020-08-13

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

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

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Your report was sent to the responsible team. Our representative will contact you by email you provided.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Policy.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you for your interest in Veeam products!
We've sent a verification code to:
  • Incorrect verification code. Please try again.
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

ty icon

Thank you!

We have received your request and our team will reach out to you shortly.

OK

error icon

Oops! Something went wrong.

Please try again later.