Automate Backup of Analysis Services Database Using SQL Server Agent Job Read more: Automate Backup of Analysis Services Database Using SQL Server Agent Job - MyTechMantra.com http://www.mytechmantra.com/LearnSQLServer/Automate_Backup_of_Analysis_Services_Database.html#ixzz1RBEEQ6ps

Backup Analysis Services Database Using SQL Server Agent Job

1. Start SQL Server Management Studio and connect to Database Engine.
2. Expand SQL Server Agent, right click Jobs and choose New Job… from the popup menu as shown in the snippet below.
3. In the New Job dialog box, provide a name for the job and then click on Steps page to create a new step.
4. In New Job Step, specify an appropriate step name and choose SQL Server Analysis Services Command as the type from the drop down list. Next you need to mention the Analysis Server Name and copy paste the below mentioned XMLA script as shown in the snippet below.

XMLA Script to Backup the Analysis Services Database

<--Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <--Object>
    <--DatabaseID>Adventure Works DW 2008 SEDatabaseID>
  <--/Object>
  <--File>D:\Program Files\Microsoft SQL Server\MSAS10.SQL2008\OLAP\Backup\Adventure Works DW 2008 SE.abfFile>
  <--AllowOverwrite>trueAllowOverwrite>
<--/Backup>