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 characters needed characters left characters exceeded

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

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 ·
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

· Write an Answer
jason_clark03 avatar image
jason_clark03 answered
10 |1200 characters needed characters left characters exceeded

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.