Schedule Backup and Restore of Analysis Services Databases

Backup your Analysis Services databases with xmla as per the following example … together with a SQL Server agent job and optionally a SSIS package, this allows you to perform unattended backups and restores of your Analysis Services databases.  Use either an Analysis Services job step in the SQL Server agent job or a SSIS package Analysis Services DDL task to complete the mission.  In the examples below, overwrite of the backup file is enabled.

 

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

<File>d:\sqldata\YourSSASDatabaseBackupFile.abf</File>

<AllowOverwrite>true</AllowOverwrite>

</Backup>

 

Likewise restore your Analysis Services database with xmla as per the following example

<Restore xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine“>

<File>d:\sqldata\YourSSASDatabaseBackupFile.abf</File>

<DatabaseName>YourSSASDatabase</DatabaseName>

<AllowOverwrite>true</AllowOverwrite>

</Restore>

 

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s