I setup DB Mirroring (on 2008) w/ SQLSrvr1 as Principal and SQLSrvr2 as Mirror (I did not use a witness)
When I tried to failover the DB from the Mirror server (SQLSrver2) using script:
ALTER DATABASE myDB SET PARTNER FAILOVER
... it failed.. (forget the exact msg but it said you need to be on Principal to do so) .. then I issued same script from Principal (SQLSrver1) and it worked fine.
Problem is -- when the Principal is in a disaster and not available, HOW can I failover to the Mirror without getting this error?