Robert, could you post the checksums for SQLFULL_ENU.iso please?
systemx
5 Dec 2011 4:13 AM
Pieter Vanhove
6 Dec 2011 8:58 PM
Hi Robert,
I was playing around with the new backup pref. options.
But when I try the function sys.fn_hadr_backup_is_preferred_replica, I always get a result 1.
This is for each replica the same, even if I change the priorities.
Any ideas?
Regards
Pieter
systemx
7 Dec 2011 6:04 AM
Here are the checksums for SQLFULL_ENU.iso if anyone needs it.
CRC-32: 5c939061
MD4: bfb3aef4281ea3677583ca2e07dbc091
MD5: 24e3f7e57c81f53f84f8ff4c773b2e96
SHA-1: 56f201082b9270a1d4db0190a97becb2f22c6144
8 Dec 2011 5:22 PM
@pieter
I am unable to reproduce this on my system. Can you post the output of the following query, replacing AppGroup1 with the name of your availability group. Thx.
select
automated_backup_preference_desc
from sys.availability_groups
where name = 'AppGroup1'
select
availability_mode_desc,
backup_priority
from sys.availability_replicas
where group_id = (
select
group_id
from sys.availability_groups
where name = 'AppGroup1')
8 Dec 2011 5:51 PM
Just to get it clear. You must supply the databasename with the sys.fn_hadr_backup_is_preferred_replica function, not the availability group name. Which makes sense because the backup is on the database level, not the availability group level.
However, specifying a non existing databasename or null as parameter for sys.fn_hadr_backup_is_preferred_replica results in a 1.
kimis
27 Nov 2013 8:23 AM
Hi Robert, question about readable secondary option - does it impact on result of sys.fn_hadr_backup_is_preferred_replica function?
in your example you use SQL-05 replica to check backup . but if it was SQL-03 or SQL-02 for example, having 'no' connection option? does it impact on backup ability?