Build security into your Microsoft SQL Server high availability plan

Overview This sample chapter, taken from Microsoft SQL Server High Availability, discusses how security affects high availability and various security techniques for working with systems that are highly available.

Learn how security affects high availability. Getting these types of security practices into place in your environment will allow you to achieve or exceed your high availability goals much more easily.

This sample chapter, taken from Microsoft SQL Server High Availability, discusses security techniques when working with systems that are highly available. The chapter covers the following topics:

• 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, logshipping, and data replication)

Title: Microsoft SQL Server High Availability
ISBN: 0672326256
Published: November 2004
Author: Paul Bertucci
Chapter: Chapter 11: High Availability and Security
Published by Sams