A typical approach to high availability in Analysis Services 2000 is to use Windows Network Load Balancing (NLB) to distribute user queries across multiple Analysis Services instances on disparate machines while also increasing availability. You keep the databases on these machines in sync with file-based backup and restore (required for large databases due to the 2GB .cab file size limitation) from a secondary server on which cube and dimension processing is performed. For more information, read the Microsoft white paper "Creating Large-Scale, Highly Available OLAP Sites" at http://www.microsoft.com/sql/evaluation/bi/creatingolapsites.asp.

Eve...