User Requirements Drive the Replication Design
As mentioned before, the business requirements will really drive your replication configuration and method. The phase zero (0) high availability assessment results will provide you with the answers to most of the detail questions that are needed to pick the right type of replication to use. The answers you gave and the path that was followed through the HA decision tree got you to this point to begin with. However, adding more thoroughness in requirements gathering is highly recommended to get a prototype up and running as quickly as possible. This will allow you to measure the effectiveness of one replication approach over the other.
Figure 7.23 depicts the factors that contribute to replication ...
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
