If you are looking for a high availability solution for Sharepoint, follow the link below. Although it is possible to create a secondary copy of the SQL database using log shipping and such, this solution from Neverfail seems to be more interesting.

Neverfail for SharePoint High Availability Solution and Disaster Recovery