Failover Clustering in Analysis Services
Analysis Services 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 R2 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.