Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Failover Clustering in Analysis Services

SQL Server 2008 Analysis Services (SSAS) natively supports Server Clusters (MSCS) in Windows Server. This enables you to design and implement highly available services in Analysis Services by using failover technologies. To better understand failover clustering technologies, see Server Clusters. Note that the concepts reviewed in that document also apply to Windows Server 2008.

See Getting Started with SQL Server 2008 Failover Clustering for a complete and detailed guide on installing and administering Analysis Services failover clusters.

Failover clustering enables recovery from a service failure in the shortest time possible. However, it is important to note that:

  • When an instance fails over the next available node all connections are lost, with the corresponding loss of uncommitted work. Most client applications should be able to handle this situation; often, hitting the refresh button in the application will bring the results back.

  • Administrative applications that process Analysis Services objects should be designed to handle failover situations.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.