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?
bschave2Asked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
Better look directly at sys.database_mirroring:
http://technet.microsoft.com/en-us/library/ms178655.aspx

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

This should get you started
http://technet.microsoft.com/en-us/library/cc917680.aspx
0
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.