question

asif128 avatar image
asif128 asked

bakup failed on primary server , sys.fn_hader_bakup_is _preferred_replica return 0

I have database in always on with 2 serves. My backup in the primary server is don't work. The backup preferences of the availability group is primary and when I run sys.fn_hadr_backup_is_preferred the result in both server is 0 . The backup priority in both server is 50. What the problem?
always-onavailability-groupsprimarybackup failed
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sagar Bhargava avatar image Sagar Bhargava commented ·
Are you passing the database name to sys.fn_hader_bakup_is _preferred_replica on the primary replica? It returns 1 if the database on the current instance is on the preferred replica. Otherwise returns 0. How are you taking the backup? SQL Native or a 3rd part tool? Any errors in the errorlogs?
1 Like 1 ·
asif128 avatar image asif128 commented ·
I passing the db name to sys.fn_hader_bakup_is _preferred_replica , And the primary and secondary replica return 0. No error in the error log , the backup don't create because the answer of sys.fn_hader_bakup_is _preferred_replica is 0
0 Likes 0 ·

1 Answer

·
jason_clark03 avatar image
jason_clark03 answered
This is not an issue with the function but sometimes it occurs by changing a configuration setting. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7cb08c5c-30b7-40d1-97e7-3302675a9d0e/sysfnhadrbackupispreferredreplica-returns-0-on-both-nodes-of-cluster?forum=sqldatabaseengine
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.