Wednesday, 14 December 2016

Backing up Analysis Services

There's a very straight forward way to backup a cube onto a shared location.


First create the folder within the shared path e.g. \\SHAREDPATH\CUBEFOLDER


Open new XMLA window and  run XMLA code below on server with the cube



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


No comments:

Post a Comment