Moving Analysis Services to a new server 1

[mrdenny]

We are moving one of our SQL Servers to new hardware. On this SQL Server is Analysis Services.

We know how to move the SQL Server from one server to another. Does anyone have any experience moving Analysis Services from one physical server to another?

I will be cross posting this in the SQL Server forums (I know that makes me evil but I need the exposure.)

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[MDXer]

Pretty straight forward process.
1) Archive your Database(s) into a .cab.
2) Move the .cab ile to the new server
3) Restore the DB from the .cab file.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mrdenny]

Cool, thanks. Looks pretty easy.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[Recce]

Hi MDXer,

Does this method also move the actual cubes within Analysis Manager ? The reason why I am asking is that we will be doing the same thing within the next few weeks.

Regards

"We know nothing but, that what we know is not the truth..." - Me

 

[MDXer]

It moves all of the structures Datasources, Cubes, Dimensions. I believe the cubes are even restored in a processed state.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Recce]

MDXer, thanks for this. I will try the above procedure

"We know nothing but, that what we know is not the truth..." - Me

 

[blom0344]

We are actually trying to do the same thing.
However after installing Analysis Services on a production server we are unable view any data.
I can process any object (cube,dimension) and the connection to the relational database works fine.
New objects created show the same problem...

SQl server is running with service packs installed, but I am unable to get hold of the service pack for analysis services. Does anyone have a clue how to get analysis services to run on my production server?

analysis service version is 8.0.194



Ties Blom
Information analyst

 

[MDXer]

http://www.microsoft.com/downloads/...2C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en

you need the sql2kasp3.exe file


Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[blom0344]

yep, fixpack and restart seem to solve the issue!

Ties Blom
Information analyst