Backup SQL Always ON 2016 Basic Availiblity Group

Availability for the Always-On Enterprise

Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby sebastian.mair » Fri Feb 10, 2017 8:10 am

hello, i have a 2 SQL Server 2016 Standard with Basic Availiblity Group. i have Databases on both hosts, but have only 2 which are on high availiblity state. so i want to backup both nodes, but the backup on the secondary replica fails, because this is a limitation of BAG. but in fact i have normal databases on the secondary node, so my question is, is it possible to exclude the database from backup on the second node? i can only exclude the complete database from veeam over the registry tweak, but i want to backup the HA Database which is active on the primary node.


any ideas?

kind regards,

sebastian
sebastian.mair
Novice
 
Posts: 8
Liked: never
Joined: Thu Apr 11, 2013 12:24 pm

Re: Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby foggy » Fri Feb 10, 2017 10:54 am

Hi Sebastian, indeed, Basic Availability Group doesn't allow backup of databases from secondary node (there's no read access on secondary replica). We already have a requirement to detect and exclude such databases from VSS processing and will address this in one of the future updates. Thanks.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] SQL 2016 Backup Failes

Veeam Logoby leigh.brewster » Tue May 16, 2017 1:20 am

Hi, I have a SQL2016 AlwaysOn setup with a primary and a secondary replica running on Server 2012R2

When trying to backup the secondary replica SQL server I get the following error:


Code: Select all
16/05/2017 11:05:17 AM :: Unable to release guest. Error: Failed to call RPC function 'Vss.Unfreeze': Error code: 0x80004005. Failed to invoke func [Unfreeze]: Unspecified error. 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: [{83df507e-cc79-44fb-979c-0ac04025ad51}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].]. 
Unable to release guest. Error: Failed to call RPC function 'Vss.Unfreeze': Error code: 0x80004005. Failed to invoke func [Unfreeze]: Unspecified error. 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: [{83df507e-cc79-44fb-979c-0ac04025ad51}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].].
Error: Failed to prepare VM for processing: Failed to call RPC function 'Vss.Unfreeze': Error code: 0x80004005. Failed to invoke func [Unfreeze]: Unspecified error. 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: [{83df507e-cc79-44fb-979c-0ac04025ad51}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x8


Any help would be great

Thanks

Leigh
leigh.brewster
Lurker
 
Posts: 2
Liked: never
Joined: Mon Nov 28, 2016 1:37 am
Full Name: Leigh Brewster

Re: SQL 2016 Backup Failes

Veeam Logoby Dima P. » Tue May 16, 2017 4:37 am

Hi Leigh,

Please reach our support team and let them investigate the application logs. Additionally, here is the thread with a similar error, take a look at suggested workaround. Thank you.
Dima P.
Veeam Software
 
Posts: 6391
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL 2016 Backup Failes

Veeam Logoby foggy » Tue May 16, 2017 10:39 am

Any chance this is a Standard Edition of SQL Server 2016?
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL 2016 Backup Failes

Veeam Logoby leigh.brewster » Tue May 16, 2017 10:46 pm

Yes STD SQL2016 why?
leigh.brewster
Lurker
 
Posts: 2
Liked: never
Joined: Mon Nov 28, 2016 1:37 am
Full Name: Leigh Brewster

Re: SQL 2016 Backup Failes

Veeam Logoby foggy » Wed May 17, 2017 4:53 pm

Then it is a known MS limitation, please see above.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby nmdange » Mon May 22, 2017 3:15 pm

According to the original post Veeam should have an update at some point to detect these databases and exclude them to stop the error from happening. Is there any ETA on when this fix might be made available? This is still an issue on 9.5 update 2.
nmdange
Expert
 
Posts: 204
Liked: 58 times
Joined: Thu Aug 20, 2015 9:30 pm

Re: Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby foggy » Mon May 22, 2017 3:16 pm

This is planned for v10.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby james-w » Wed Sep 06, 2017 6:19 am

Hi,

Is this still planned for v10?

Thanks.
james-w
Lurker
 
Posts: 1
Liked: never
Joined: Wed Sep 06, 2017 6:18 am

Re: Backup SQL Always ON 2016 Basic Availiblity Group

Veeam Logoby foggy » Wed Sep 06, 2017 1:37 pm

Yes.
foggy
Veeam Software
 
Posts: 14904
Liked: 1096 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Exabot [Bot], Google Feedfetcher and 33 guests