Sorry if my question seems too simplistic to others out there. I am trying to learn OLAP and since I am not very familiar with it, I would like to get some input from folks who are well versed using it.

I would like to know if anyone has looked into a backup/recovery strategy for OLAP cubes. I am not sure if there is something special that needs to be done for backing up OLAP cubes or is the same as backing up SQL tables. We use ArcServe or native SQL backup/restore wizards to do our backups would this work with OLAP data cubes.

What is the difference between a table and a cube other than the fact that it is 3 dimensional data, are there things that I am missing here.

If someone has implemented a strategy for data cubes, can you please send me samples, thoughts, suggestions etc.

Appreciate it very much.

Yakuta