MicrosoftBoth example queries contain invalid column names. Please clarify whether the queries can or should be run on the primary or secondary.
MicrosoftThank you for the careful review—you're absolutely right. I’ve updated the queries to reference the correct column, and confirmed that both should be executed on the primary database. Please take another look and let me know if there’s anything else you’d like me to adjust.
For the first query, I would use:
-- Run on primary DB
SELECT
link_guid
, partner_server
, partner_database
, replication_state_desc
, replication_lag_sec
, last_replication
FROM sys.dm_geo_replication_link_status;I think the additional data is helpful. Thanks for updating the article so quickly!