Backup and Restore Analysis Service Databases

[koc]

I am new to Analysis Services, do I have schedule Analysis Service database backup job just like I do for SQL Server databases? Or I just need to backup the C:\Program Files\Microsoft Analysis Servcies\Bin\msmdrep.mdb file. Thanks in advance.

[rmiao]

You can archive and load cubes in AS console.

[koc]

Thanks rmaio. I tested it, but I 'm just wondering if I had to do it everyday just like doing database backup??

[rmiao]

Depends on how often do you process cubes.

[koc]

Thanks again. Is there a scehdule in Analysis Service I can use to run the backup everyday??

[rmiao]

You can schedule to run msmdarch command in windows task scheduler.

[koc]

Thank you rmaio.