Monday, August 12, 2013

SSAS - XMLA script to Backup Analysis Database


 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.

1 comment: