Hi
In SQL Always on configuration you can configure the backup to run a backup in the following way:
Prefer Secondary Automated backups for this availability group should occur on a secondary replica. If there is no secondary replica available, backups will be performed on the primary replica
Secondary only All automated backups for this availability group must occur on a secondary replica
Primary All automated backups for this availability group must occur on the current primary replica
Any replica Backups can occur on any replica in the availability group
If for example the selected backup setting is Prefer Secondary. In order for DPM to find out which server holds a secondary role, it runs a SQL Query
If the query cant be ran at all, then we might see odd behaviors.
Couple things that can cause this query not to run:
-
NT AUTHORITY\SYSTEM does have at least public permission on the SQL instance where the Always on is configured.
-
Cant connect to SQL instance
DPM is expecting one of these two responses: The always on group name or 0.
If we cant run the Query at all, we will get a null and null means the group isnt ready for a backup and we will get the following event (DPM 2012 UI, Monitoring/Jobs tab
Type: Consistency check
Status: Failed
Description: DPM was unable to determine the right node for backing up the Availability Group database and hence failed the backup.
Database: <DB Name> (ID 32029)
End time: Date/Time
Start time: Date/Time
Time elapsed:
Data transferred:
Cluster node -
Source details:
Protection group:
Items scanned: 0
Items fixed: 0
Recommended area to start troubleshooting the issue.
From each SQL node during the Date/Time of backup failure review the DPMRA logs located in the following location <DPM Install Path>/Microsoft Data Protection Manager/DPM/Temp
Identify if you have any Warnings being shown before the following is logged Normal AvailabilityGroup Role: NotReadyForBackup.
Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Dwayne Jackson II.
[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
- Edited by
Dwayne Jackson IIMicrosoft employee
Thursday, January 09, 2014 1:54 PM
needed to add more