-
- Novice
- Posts: 6
- Liked: never
- Joined: Sep 29, 2016 12:12 am
- Full Name: Peter
- Contact:
VSS Error with SQL Server Compact Instance
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
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
-
- 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
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.
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.
-
- Novice
- Posts: 6
- Liked: never
- Joined: Sep 29, 2016 12:12 am
- Full Name: Peter
- Contact:
Re: VSS Error with SQL Server Compact Instance
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.
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.
-
- Novice
- Posts: 3
- Liked: 2 times
- Joined: May 19, 2017 7:03 am
- Contact:
Re: VSS Error with SQL Server Compact Instance
Sounds a lot like the problem in this thread: veeam-backup-replication-f2/bunch-of-se ... 37483.html
-
- 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
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
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
-
- 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
How was this ever solved for you? I am experiencing the same issue.
-
- Novice
- Posts: 6
- Liked: never
- Joined: Sep 29, 2016 12:12 am
- Full Name: Peter
- Contact:
Re: VSS Error with SQL Server Compact Instance
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
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
-
- 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
Hey Peter,
Thanks for letting us know what solved your issue! Appreciated
Thanks for letting us know what solved your issue! Appreciated
Who is online
Users browsing this forum: Baidu [Spider], Bing [Bot] and 58 guests