high availability 2

  • Imagine you are a DBA for a mid-sized company with twelve (12) SQL database servers. Suppose you were asked to implement the simplest and most cost-effective form of high-availability method. Recommend a solution for the provided situation and provide a rationale for your response.
  • As a DBA, you need to account for all of the server downtime and react to the unforeseen occurrences. Imagine you are responsible for maintaining the availability of twelve (12) database servers. Review the Microsoft Developer Network articles titled, “Database Mirroring (SQL Server)” located at http://msdn.microsoft.com/en-us/library/ms189852.aspx, and “AlwaysOn Availability Groups (SQL Server)” located at http://msdn.microsoft.com/en-us/library/hh510230.aspx. Then, recommend the service that you would most likely use, and provide a rationale for your response.

This is a discussion post questions and only requires 2 paragragphs