xmla script for automate ssas database backup

• alokkumar_srivastava

  Mr or Mrs. 500

  Points: 508

  More actions

  October 5, 2010 at 8:33 pm

  #239282

  Hi

  WE want to write one xmla script to take backup of all ssas data base in production envirnment to take back up in on go So we don't need take back up one by one .

  I am new in xmla .Please guide me to write script for this requirement .Sample of script will kelp me to move forward .

  Regards,

  Alok

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  October 5, 2010 at 8:51 pm

  #1232197

  I find that the easiest way to get started with XMLA is to look at examples and the easiest way to get some examples is to use Management Studio. Most (maybe even all) of the activities that you can do by right clicking have the option to script the XMLA for the task you are trying to perform.

  e.g. to backup a database, I right clicked, selected backup, de-selected "Encrypt back file", scripted the result which looked a bit like

  <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

  <Object>

  <DatabaseID>Your database name</DatabaseID>

  </Object>

  <File>Your back filename.abf</File>

  </Backup>

  Your next best resource is to use Books Online which you should have installed onto your workstation. Search for XMLA in the index and start reading.

• alokkumar_srivastava

  Mr or Mrs. 500

  Points: 508

  More actions

  October 5, 2010 at 9:14 pm

  #1232203

  Hi Thanks to reply that is really helpful to learn .

  But i am stuck to write one xmla script that will take back up for all ssas database in one go , It's straight forward to write script for one data base or we can easily see in management stdio .

  Any ideal to write or join xmla script for number of data base will helpful to save my a lot effort .

  Thanks & Regards,

  Alok