Combining SharePoint and Database Mirroring
Solution 1:
We told NOT to even try it with SharePoint by MS (this was 1.5 years ago when we first started planning our SharePoint 2007 implementation).
Solution 2:
We ended up using a product called Neverfail to add HA our MOSS implementation. It provides a continuous replication of both the SQL server and the MOSS server. Far more reliable with the both the fail over and the fail back scenarios.