Backing up an SSAS OLAP Cube Database, by command

So you have Dynamics AX 2009 up and running, you have deployed everything, got the SPN's set and working, and the OLAP cubes deployed.

You go and run Role Centers, and some KPI's are failing and some Cubes and reports are. You investigate, and go through the motions of fixing the OLAP cubes. (A later post on this to come)

After getting the cubes fixed, dimensions set, KPI's working, and the underlying Data View for the Cube Database all correct, what's next?

Well you will need to make sure and create a SSIS packge, that will backup a SSAS Cube Database. But, looking at the SSAS command task, there is not a simple option for this.

The following is the command used to backup the SSAS OLAP Cube Database with, for an SSIS package, that can execute as a scheduled job.:

SSAS Tag Based Backup Command

The above is stored as a link to a text file, because the command is Tag based, and blogger wants to make it into HTML.

Notice there is a password section. If this is given, then the password is set as that password, and must be supplied if used for restore.

This backup process takes and backups to the file location, and file name the meta-data that describes the Cubes and all that make up those cubes. This does not back up any data for these cubes.

If a restore is needed, simply take and restore from the file, and re-process all the cubes. This will get OLAP back up and running for your cubes, with your latest transactional data processed.

Well more to come, including looking at Role Centers, SSRS and SSAS across forest and domains. See you then!




"Visit the Dynamics AX Community Page today!"