Archiving OLAP Cubes 
Author Message
 Archiving OLAP Cubes


Does anyone have any idea why when archiving a cube through analysis
manager the resulting cab directory/files are 40mb but when using the
msmdarch command to archive the same cube the cab directory is only

When using analysis manager 68 files are created in the cab folder
many of them ending in an underscore character.

Msmdarch only leaves me these two files


my msmdarch command looks like this:

"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a
testserver "\Program Files\Microsoft Analysis Services\Data\"
"Data_Cube" "e:\archives\"

I checked the error logs and there were no errors.

Can anyone tell me what i am doing wrong?

Any help would be greatly appreciated,



Mon, 15 Aug 2005 22:55:01 GMT
 Archiving OLAP Cubes

I assume that you only save the analysis server's
structure. Such as definition of cubes and Dimensions.
The archive option in Analysis Manager secures the whole
database - including the data itself. That is the

Whether Msmdarch has a switch to achieve that, I do not
know. Have you checked with the documentation?


Mon, 15 Aug 2005 23:27:55 GMT
 Archiving OLAP Cubes
Thanks Lutz,

Thanks for the quick reply.

the thing is that the msmdarch command only has one switch for archiving
'/a'. I think you right it probably is only archiving the structure.
Have you heard of any way to archive the data as well as I do through
analysis services.

I need to be able to write some code to do this to around 300 cubes and
i don't want to have to do it manually in anlysis services.

Thanks for you help,


*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!

Tue, 16 Aug 2005 00:02:35 GMT
 [ 3 post ] 

 Relevant Pages 

1. How to backup/archive olap cubes

2. Backup/archive OLAP cubes - changing datasources

3. Getting errors when archiving OLAP cube

4. Archive OLAP cube problem

5. add-in to archive / backup individual cubes and virtual cubes

6. Convert CUBE from OLAP SQL Server - Local Cube

7. Cubes to Web (Web-interface to OLAP Cubes)

8. Cube not listed in Excel PivotTable OLAP Cube list

9. With OLAP..Can process foodmart cubes but not my cubes

10. Virtual OLAP Cubes vs. Source MOLAP Cubes

11. Seagate Info cubes / MS Olap cubes

12. Create Local Cube From OLAP Cube

Powered by phpBB® Forum Software