To Check Status of Mirroring

--use this on principal and mirror select * from sys.database_mirroring

--use this on witness select * from sys.database_mirroring_witnesses