Expert Cube Development with SSAS Multidimensional Models

Copying databases between servers

There are several scenarios where we may need to copy an Analysis Services database from one server to a different server. Here are a couple of examples:

• We have several frontend servers directly accessible by users in the DMZ area of the network and one backend server inside the internal network. When the cube is processed on the internal server, it needs to be duplicated to the frontend servers so it can be queried by our users.
• We have two powerful Analysis Services servers and several cubes. Half of the cubes are processed on one server and half are processed on the other. When both servers have finished processing, the databases are synchronized between the two servers so they both have the same data and can ...