It is not uncommon for customers to implement more than one high-availability solution to meet multiple, if not all, data availability requirements for their business. Multiple solutions provide additional data redundancy, as well as reduced possibility of data loss and user downtime in the event of a failure. Microsoft has published the following documents describing the benefits and methods for implementing multiple high-availability solutions. These documents should be reviewed by any customer looking to create such a solution:
-
SQL Server High Availability Solutions at http://msdn.microsoft.com/en-us/library/ms190202.aspx.
-
Database Mirroring and Log Shipping (Microsoft Docs) at http://msdn.microsoft.com/en-us/library/ms187016(v=sql.105).aspx.
-
Database Mirroring and Log Shipping Working Together (SQL Server Best Practices Article) at http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping.docx.