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: 13899
Liked: 1012 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: Google [Bot] and 8 guests