AVB (7/15/2010)
I was thinking about this...In a mirroed environment does it fail over if the database is taken offline/deleted/corrupt/inaccessible yet the server is fine?
depends....
you can't offline a Principal database.
you can't delete a Principal database.
if it is logical corruption, it will grab the bad page from the mirror in 2008. In 2005, it will only throw event 823. (i think it is 823???)
sorta hard to test physical corruption, but my guess would be hung server.