VSS Error with SQL Server Compact Instance

Availability for the Always-On Enterprise

VSS Error with SQL Server Compact Instance

Veeam Logoby cojaxx8 » Mon May 22, 2017 6:08 am

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
cojaxx8
Novice
 
Posts: 4
Liked: never
Joined: Thu Sep 29, 2016 12:12 am
Full Name: Peter

Re: VSS Error with SQL Server Compact Instance

Veeam Logoby Mike Resseler » Mon May 22, 2017 6:33 am

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.
Mike Resseler
Veeam Software
 
Posts: 3290
Liked: 366 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: VSS Error with SQL Server Compact Instance

Veeam Logoby cojaxx8 » Fri May 26, 2017 11:31 am

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-2012-sp2-sqlvdi-error-t23928.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.
cojaxx8
Novice
 
Posts: 4
Liked: never
Joined: Thu Sep 29, 2016 12:12 am
Full Name: Peter

Re: VSS Error with SQL Server Compact Instance

Veeam Logoby SdC » Thu Jun 08, 2017 5:31 am

SdC
Lurker
 
Posts: 2
Liked: 2 times
Joined: Fri May 19, 2017 7:03 am

Re: VSS Error with SQL Server Compact Instance

Veeam Logoby Mike Resseler » Mon Jun 12, 2017 5:49 am

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
Mike Resseler
Veeam Software
 
Posts: 3290
Liked: 366 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: benks, Bing [Bot], Google Feedfetcher and 22 guests