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

Application-Aware Image Processing failure with SQL 2012 SP2 case-sensitive collation database

KB ID: 1944
Product: Veeam Backup & Replication
Version: All
Published: 2014-10-30
Last Modified: 2020-08-13
Languages: FR

Challenge

Job using Application-Aware Image Processing fails during VSS processing with:

Unfreeze error: [Backup job failed. Cannot create a shadow copy of the volumes containing writer's data. A VSS critical writer has failed. Writer name: [SqlServerWriter]. Class ID: [{}]. Instance ID: [{}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]

Cause

This is a known issue documented in this Microsoft KB: http://support2.microsoft.com/kb/2987610

Solution

Run this query to see if the issue is present:

SELECT 1 FROM SYS.AVAILABILITY_REPLICAS AS AR INNER JOIN SYS.DATABASES AS D ON DB_ID(N'xxxx') = D.DATABASE_ID AND AR.REPLICA_ID = D.REPLICA_ID INNER JOIN SYS.DM_HADR_AVAILABILITY_REPLICA_STATES ST ON AR.REPLICA_ID = ST.REPLICA_ID AND ST.ROLE = 2

If you receive the following, this confirms the issue.

Invalid object name 'SYS.AVAILABILITY_REPLICAS'.

This issue is resolved by the following Microsoft KB: http://support2.microsoft.com/kb/2983175

KB ID: 1944
Product: Veeam Backup & Replication
Version: All
Published: 2014-10-30
Last Modified: 2020-08-13
Languages: FR

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.
We're working on it please try again later
Knowledge base content request
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.

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 go back try again later.