asked on

Steps to move cubes from Server A to Server B

I have been tasked with moving some SQL Server reporting cubes from Server A in Datacenter A to Server B in Datacenter B and want to make sure I'm not missing anything (this is way outside my usual ball park of operations - I'm mostly an Oracle guy).

So far I have identified:

* There is a pair data warehouse databases that need moving - Simple DB backup and Restore for initial setup should work
* There are 4 SSAS Cubes. I believe this is a backup of each cube and restore on new server
* There are several SSIS packages that need to be exported individually and re-imported into the new server
* There are several SQL Server Agent jobs that refresh these cubes that will need to be copied to the new server

Are there any other steps I need to be aware of or pieces that might need to be moved that I haven't listed above.

Thanks

EugeneZ

what is your SSAS version SP? (source and destination)

I'd make sure on destination you have all needed set access to these cubes
you can just backup restore SSAS DB with all inside
for cubes
Deploy a Created Cube to a Different SSAS Server
http://help.zapbi.com/Zap%20CubeXpress/CurrentVersion/Content/Topics/HowTo/ImportCreatedCube.htm
Multidimensional Model Solution Deployment
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/multidimensional-model-solution-deployment

Backup and Restore of Analysis Services Databases
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/backup-and-restore-of-analysis-services-databases

Steve Wales

ASKER

Both DB's are 2008 (10.00.5500 is the version I believe)

EugeneZ

there is no harm to patch SSAS to the latest service pack (you can do this later ),
is it the answer that you are looking for?

Steve Wales

ASKER

No, what I was really after was check a checklist to make sure I haven't missed any components. Have a really old system that still needs to be supported and wanted to make sure I didn't miss anything in trying to move all the pieces.

ASKER CERTIFIED SOLUTION

EugeneZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve Wales

ASKER

Well, it seems to be folding together nicely at the moment. Have all the pieces restored and my SSIS/SSAS guy is making sure it all ties together. Thanks.