SQL High Availability & Log Shipping

High Availability

For clients that need that extra assurance with SQL Server.  High Availability provides very nice options for those that choose the enterprise edition of SQL Server.  Most clients configure this with 2 synchronous clients and a 3rd machine as asynchronous, generally this is a reporting server.

Experience is configuring and testing this new environment is a must.  We also would create a runbook for a migration event to lay out restore times and other steps for success.  

 

SQL Log shipping

Log shipping is an easy way to setup resources for a reporting server.  Configuration and setup are straight forward.  Again, we have tools and jogs to assist our clients with implementing this technology.