SSAS – XMLA script to Backup Analysis Database

August 12, 2013

This XMLA script that supports SQL
Server Analysis Service is used to take the backup of Analysis database. Change
the name of Analysis DB name (ID) and path where backup needs to be taken in the script before execution.

<Backup xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>

<Object>

<DatabaseID>MyAnalysisDB</DatabaseID>

</Object>

<File>G:MyAnalysisDB.abf</File>

<AllowOverwrite>TRUE</AllowOverwrite>

</Backup>

This script is useful to automate the backup process of Analysis
database using SQL Server Agent.

Related Posts

Leave a Reply Cancel reply