Check DB Mirroring Status

Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Database mirroring is supported in SQL Server Standard and Enterprise.

Database mirroring offers a substantial improvement in availability over the level previously possible using Microsoft SQL Server and provides an easy-to-manage alternative or supplement to failover clustering or log shipping. When a database mirroring session is synchronized, database mirroring provides a hot standby server that supports rapid failover with no loss of data from committed transactions. During a typical mirroring session, after a production server fails, client applications can recover quickly by reconnecting to the standby server.

Note
You cannot mirror the master, msdb, temp, or model databases.

select DB_Name(database_id) as DBName,
mirroring_role_desc,mirroring_state_desc,
mirroring_safety_level_desc,mirroring_connection_timeout
from sys.database_mirroring
where mirroring_guid is not null