查询MSSQL数据库同步状态

SELECT database_id,synchronization_state_desc, last_hardened_lsn, last_commit_lsn,is_local 

FROM sys.dm_hadr_database_replica_states 

WHERE database_id = DB_ID('LQtex');

 

select * from  sys.databases;