Chapter 11. High Availability and Security

THE KEY TOPICS IN THIS CHAPTER ARE

  • Applying security standards and sound techniques to your HA environment (with well thought out roles and permissions schemes)

  • Creating schema-bound views to protect tables from being changed or dropped accidentally (to minimize these types of inadvertent failures)

  • Security considerations for each major HA option (MSCS, SQL clustering, log shipping, and data 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.