cancel
Showing results for 
Search instead for 
Did you mean: 

Backup Exec 2014 and SQL AlwaysOn backup

apomazkin
Level 5

How can I set backup of DB on AlwaysOn SQL?
I have agent on both sql servers, where create alwayson DB.
Both server have DB in they local resources. but for Exchange DAG i have different method add DAG in Backup Exec.
I can't find manual for creating alwayson backup.

1 ACCEPTED SOLUTION

Accepted Solutions

VJware
Level 6
Employee Accredited Certified

This seems to be a Microsoft limitation as per - https://msdn.microsoft.com/en-us/library/hh245119.aspx

Verbatim from the above KB -

  • BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it is executed on secondary replicas. Note that copy-only backups do not impact the log chain or clear the differential bitmap.

As you can see, even MS does not support full backups of the secondary node. It supports only copy backup.

View solution in original post

4 REPLIES 4

CraigV
Moderator
Moderator
Partner    VIP    Accredited

apomazkin
Level 5

This is very strange support of alwayson. 

VJware
Level 6
Employee Accredited Certified

This seems to be a Microsoft limitation as per - https://msdn.microsoft.com/en-us/library/hh245119.aspx

Verbatim from the above KB -

  • BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it is executed on secondary replicas. Note that copy-only backups do not impact the log chain or clear the differential bitmap.

As you can see, even MS does not support full backups of the secondary node. It supports only copy backup.

apomazkin
Level 5

Thanks)