Comprehensive data protection for all workloads
Post Reply
cojaxx8
Novice
Posts: 6
Liked: never
Joined: Sep 29, 2016 12:12 am
Full Name: Peter
Contact:

VSS Error with SQL Server Compact Instance

Post by cojaxx8 »

Hi Guys,

Is anyone else seeing VSS errors with SQL Server Compact Instances? I have narrowed it down to the servers that have Azure AD Sync installed.

Unable to release guest. Details: 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: [{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}]. Instance ID: [{fb8fe17d-ec48-4f71-948d-f443e076e679}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]


These warnings all on different servers (for different clients) and is always the server running Azure AD Sync.

The solution in the past has been to just powercycle the server, and that keeps it happy for another few days, but eventually reappears.

Is anyone else seeing this?

Regards,
Peter
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by Mike Resseler »

In the backend Azure AD sync is using SQL server so for some reason the SQL server writer goes into error.

Can you start with a vssadmin list writers (elevated command prompt) and look at the output? the SQLserverwriter is probably in an error state and (hopefully) gives you some more information. The event log should also give you some information.
cojaxx8
Novice
Posts: 6
Liked: never
Joined: Sep 29, 2016 12:12 am
Full Name: Peter
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by cojaxx8 »

Hi MIke,

vssadmin list writers shows this.
Writer name: 'SqlServerWriter'
Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
Writer Instance Id: {fb8fe17d-ec48-4f71-948d-f443e076e679}
State: [8] Failed
Last error: Non-retryable error

The event log shows the following error.

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=1484. Thread=12052. Client. Instance=LOCALDB#SHB929F2. VD=Global\{666AAA47-7A18-4785-84AC-7A1C997A6AFF}4_SQLVDIMemoryName_0.

I was able to find this solution (veeam-backup-replication-f2/sql-server- ... 23928.html), but in his instance I believe a full version of SQL 2012 was being used. The version that comes with Azure AD Sync is 2012 LocalDB, which is different to Express. I don't think you can apply service packs to it in the same way. I will try downloading the latest SQL 2012 SP but I recall doing this last time and it said no instances were found.
SdC
Novice
Posts: 3
Liked: 2 times
Joined: May 19, 2017 7:03 am
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by SdC »

Sounds a lot like the problem in this thread: veeam-backup-replication-f2/bunch-of-se ... 37483.html
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by Mike Resseler »

Hi Peter,

Sorry for my late reply. I missed it with travel last week. Can you please create a support call? Our engineers will be able to dive deeper into the logs to see what is going wrong. Please post the case ID here and the follow-up after that

Thanks
Mike
SmithErick
Novice
Posts: 9
Liked: never
Joined: Jun 13, 2013 3:37 pm
Full Name: Erick Smith
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by SmithErick »

How was this ever solved for you? I am experiencing the same issue.
cojaxx8
Novice
Posts: 6
Liked: never
Joined: Sep 29, 2016 12:12 am
Full Name: Peter
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by cojaxx8 »

Sorry I don't think I got an email notification about this.

I've had a bit of success with making sure the latest SP for SQL (2012 SP4 Local DB)
https://www.microsoft.com/en-us/downloa ... x?id=56042

Just make sure you download the Local DB one. I made the mistake before of downloading the full version!

ENU\x64\SqlLocalDB.msi
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: VSS Error with SQL Server Compact Instance

Post by Mike Resseler »

Hey Peter,

Thanks for letting us know what solved your issue! Appreciated
Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot] and 58 guests