I'm currently prepping for a MOSS Disaster Recovery session with a customer and came across the following material on Technet: http://technet.microsoft.com/en-gb/events/bb530366.aspx
Whilst the training material goes through the basics of the Recycle Bin etc what I found particlularly useful was the PowerPoint slide deck as it lists Pro's and Con's of the different approaches - SharePoint Native backup vs SQL Backup.
The PowerPoint also depicts failover methods like SQL Clustering and Log shipping also listing Pro's and Con's of each one. The only downside is that it does not mention SQL mirroring.
Get the PowerPoint from here http://download.microsoft.com/download/a/b/1/ab13fe7e-2b58-4173-9a7e-f3140e215181/DSK-106_PPT_and_Transcript.exe