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.

3 comments:

  1. Very nice blog. I am really very happy to visit your blog. Now I am found which I actually want. I check your blog everyday and try to learn something from your blog. Thank you and waiting for your new post.360DigiTMG data science course

    ReplyDelete
  2. I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place
    360digitmg

    ReplyDelete