Hi Michael. I agree.
I verified one more time.
select sys.fn_hadr_is_primary_replica ( 'xxxxxx' ) -----> this returned 0
(1 row(s) affected)
Also the AG group under "Availability Groups" in the Object Explorer shows "Secondary".
BACKUP LOG [xxxxxx] TO DISK ='F:\CRM\Backups\xxxxxx\yyyyyyy.bak' WITH COPY_ONLY
This Resulted in :
Msg 3059, Level 16, State 1, Line 21
This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.
Msg 3013, Level 16, State 1, Line 21
BACKUP LOG is terminating abnormally.
I can run the backup with out COPY_ONLY and it works on secondary! This is the exact opposite behavior I would expect.
ON Primary I can run the backup both with and without COPY_ONLY.