I have looked around and am having a bit of a problem getting a job or something setup that will monitor a database mirror on SQL 2005.
I have seen a couple of post here and there that say's to query the Database Mirror (or something like that) table in MSDB however that table does not exist. Do I need to setup one of the 4 alerts on the mirror before that table is created.
Or is there another solution, or can someone point me in the direction of how to setup up a alert that when the database fails over from the principle to the mirror I get an email notification
Thank you in advance for the help