BackingUp Multiple Analysis Service Databases

• cmt

  Newbie

  Points: 2

  More actions

  February 14, 2007 at 5:45 am

  #116210

  Question: How does one backup more than one Analysis Service Databases ?

  An example that I saw for one Database is using

  a Sql Server Analysis Services command like this one for Database OLAP:

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

  <Object>

  <DatabaseID>OLAP</DatabaseID>

  </Object>

  <File>OLAP.abf</File>

  <AllowOverwrite>true</AllowOverwrite>

  </Backup>

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  February 14, 2007 at 8:28 am

  #689719

  You should be able to batch the backups using the Batch element - see below for an e.g.  Just note that I have  used the AllowOverwrite element and set it to true, you may not want to do this in a production environment (ie you'll prob want to create new BU's each time).

  <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="false">

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

      <AllowOverwrite>true</AllowOverwrite>

      <Object>

        <DatabaseID>MyDB1</DatabaseID>

      </Object>

      <File>MyDB1.abf</File>

    </Backup>

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

      <AllowOverwrite>true</AllowOverwrite>

    <Object>

      <DatabaseID>MyDB2</DatabaseID>

    </Object>

    <File>MyDb2.abf</File>

  </Backup>

  </Batch>

   

  Cheers,

   

  Steve.