SQL-DBA-01 - Friday, May 19, 2017 1:58 PM
Not at all weird. Only the principal replica and any read-only replicas can show properties, because that requires reading system tables from the database. If the database is unavailable (normal for the non-readonly secondaries), those tables can't be read and so the show properties will throw an error.
As per the error message:
Either data movement is suspended or the availability replica is not enabled for read accessthe availability replica is not enabled for read access.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability