It shouldn't be a problem using SQB2MTF, I've done this in the past and our backups are encrypted, 'Stripped' and compressed.

Of course I am assuming that by stripped you mean...

A bit of digging around in the System objects found what I needed.

SELECT sys.fn_hadr_backup_is_preferred_replica ( 'DatabaseName' )

Returns a 1 if it is the secondary replica, and 0 on the primary.

I'm...

While I think the article has merit, the fact that the table is created in msdb breaks another rule . . . . . . . I'm fairly sure that...