How to schedule SSAS Database backup?

2.  Select the New Job… option.
3.  Enter a Job name to identify the job
4.  Go to Steps page
5.  Click New… button
6.  After entering the Step Name, select SQL Server Analysis Services Command as the job type.
7.  Enter the server name.
8.  Enter the following command. You will need to change the SSAS database name and the backup name. <Backup xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“>
  <Object>
    <DatabaseID>AdventureWorksDW</DatabaseID>
  </Object>
  <File>AdventureWorksDW.abf</File>
  <AllowOverwrite>true</AllowOverwrite>
  <Password>password</Password>
</Backup> 9.  Click the OK button.
10. Go to the Schedule page and create a schedule as per your requirements. ]]>

Leave a comment

Your email address will not be published.