SQL Server Performance

How to move Cube to another server

Discussion in 'SQL Server 2005 Analysis Services' started by sramesh, Jun 13, 2007.

  1. sramesh New Member


    How to move a cube from one server to another one server.

    I am using sql server 2000.

    I am new to analysis.

    Please help me.

    S. Ramesh
  2. satya Moderator

    There are several ways of doing this, the best way is to use Archive and Restore. First Archive the Database on Server A then Restore it on Server B. This will move the Data as well as the cubes and dimensions. You can also simply register Server B and Server A in the same Analysis Manager and then copy the database from Server A and paste it to Server B. This will move just the cube and dimension definitions.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page