Microsoft SQL Clustering Core Capabilities
SQL Server allows fail-over and fail-back to or from another node in a cluster. In an “active/passive” configuration, an instance of SQL Server will be actively servicing database requests from one of the nodes in a SQL cluster (active node). Another node will be idle until, for whatever reason, a fail-over occurs (passive node). With a fail-over situation, the secondary node (the passive node) will take over all SQL resources (databases and MS DTC) without the end-user ever knowing that a fail-over has occurred. The end-user might experience some type of brief transactional interruption because SQL clustering cannot take over “in flight” transactions. However, from the end-user's point-of-view, they ...
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.
