06-23-2015 05:09 AM
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.
Solved! Go to Solution.
06-24-2015 10:30 PM
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.
06-23-2015 05:23 AM
06-24-2015 02:36 AM
This is very strange support of alwayson.
06-24-2015 10:30 PM
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.
07-08-2015 11:26 PM
Thanks)