SSAS – XMLA script to restore the Analysis database – SQL Circuit

SSAS – XMLA script to restore the Analysis database

This script provides an easier way of
restoring the analysis DB and it is useful when replica or snapshot of analysis
DB is required in automate fashion. Change the path of your backup (.adf) file
and your SQL Server OLAP data folder in the script before execution.

<Restore
xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
  <File>G:MyAnalysisDBBackup.abf</File>
 
<DatabaseName>MyAnalysisDBName</DatabaseName>
  <AllowOverwrite>TRUE</AllowOverwrite>
  <DbStorageLocation
xmlns=”http://schemas.microsoft.com/analysisservices/2008/engine/100/100″>C:Program FilesMicrosoft SQL
ServerMSAS11.SQL2012OLAPData
</DbStorageLocation>
</Restore>

 

 

Following are the benefits of this
script:
1. Easier way of restoring the analysis DB
2. Helpful in automating the restore process
3. Can be utilized for creating replica or snapshot of
DB in an automated way.

Leave a Reply

Your email address will not be published. Required fields are marked *