Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft