Hi,

I can backup and restore databases on Microsoft SQL server Analysis Service 2008 using GUI as from Backup SSAS

I want to schedule backup and restore it to another server every night. so what i did is : I scripted out the backup and restore process from the GUI. Created a new SQL server agent job in database engine and added a "Run SSAS query" step. Copied the scripts to this step. But it fails. the scripts that the GUI copied out look like:

<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <DatabaseID>DB</DatabaseID>
  </Object>
  <File>C:\Backup\DB.abf</File>
  <AllowOverwrite>true</AllowOverwrite>
</Backup>

<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <File>\\server\C$\Backup\DB.abf</File>
  <DatabaseName>DB</DatabaseName>
  <AllowOverwrite>true</AllowOverwrite>
</Restore>

Any help please?