Backup script for AS

From DataSelf Knowledge Base
Jump to navigation Jump to search

For SSAS 2005 and SSAS 2008?

SQL Server Job Step configuration to back up a cube DB:

Type: SQL Server Analysis Services Command Run as: SQL Server Agent Service Account

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

<Object>

<DatabaseID>DataSelf BI for Accpac</DatabaseID>

</Object>

<File>C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Backup\FileName.abf</File>

<AllowOverwrite>true</AllowOverwrite>

</Backup>