Report Portal

Backing up an Analysis Services Database automatically

Backing up an Analysis Services database is one of the easiest things you can do while managing your OLAP databases. It is indeed very straight forward. Log on to SSMS -> right click your OLAP db, select Backup, fill in the details and press OK. Job done. But there are many more things that I want to talk about.

First, apart from GIU, you can use XMLA script to backup your database. You really don't need to be an XMLA expert to do that. When you are on the Backup dialog box, use the script command to generate the XMLA script. See below:


Tags: management, backup, script


2007-2015 VidasSoft Systems Inc.