Another alternative is to choose for database mirroring, also supported scenario. Please keep in mind that besides configuration of SQL server is more complex. You also need to make changes to CRM, which can be forgotten easily.
For example you need to change some settings in the registry on the server where the web application is installed:
1) Locate: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM\
2) Change: configdb
Data Source=MSCRM_Primary\SQL1;Failover Partner=MSCRM_Mirror\SQL2;Initial Catalog= MSCRM_CONFIG;Integrated Security=SSPI
You can image when you do node switch and forget this entry your CRM application will crash. More details at: http://technet.microsoft.com/en-gb/library/hh699791.aspx.
More background about database mirroring:
PS If you wondering about the image, read this article about Droste Effect :-)