Backing up an OLAP Cube

[pto]

Hello All,

I have been assigned the task to try and find out how to backup OLAP Cubes. I found how to backup to a tape but what I am looking for is the T-sql syntax. I need to test a backup and restore of a cube. We have several cubes on our server that no one knows who they are for. I don't want to delete just in case someone claims them later. I would appreciate any suggestions.

 

[DiegoErnesto]

Hello;

Look, I say that I do.

Open &quot;Analysis Manager&quot; and select the OLAP database, right click, and select &quot;Archive database&quot;; this process generate <file>.CAB on disk, backup this file.

And, when you want restore, restore this file to disk and open &quot;Analysis Manager&quot; and right click over OLAP server and select &quot;Restore Database&quot;

I hope to help you and Good luck.

 

[pto]

Tried that however it failed at the restore. It took less than a minute to backup and was taking upto 2 hours to restore.

Thanks for the help.