how to find the principal database for a mirored database in ms sql

I inherited a database from an ex employee that utilizes mirrored databases. Can anyone shed some light on what these are and how I can find the principal database?
Who is Participating?
lcohanConnect With a Mentor Database AnalystCommented:
Better look directly at sys.database_mirroring:

--return all principals on that instance
select * from master.sys.database_mirroring where mirroring_role =1
Hi bschave2,

This should get you started
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.