XML script needed to create a current date folder and backup to be taken to that

Question

Hi All,

I want take a Analysis server database backup on a daily basis. 

I need a XML script to a folder with current date and the backups to be taken to this folder. 

<Backup xmlns="http://microsoft.com/analysisservices">
  <Object>
    <DatabaseID>ABC</DatabaseID>
  </Object>
  <File>C:\backup</File>

Please let me know, is this automation can possible with XML?

Thanks

K

Answer 1

Why with XML and not with SQL server tools?