SSAS Backup-Restore

· SSAS
Authors

Suppose you need to backup/restore a SSAS DB to a different location, don’t start messing around with DataDir/BackupDir etc parameters but include full path names in your XMLA script like this.

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

SSASDBName

<File>X:\SQL2008R2\SSASBACKUP\SSASDBName.abf</File>

<AllowOverwrite>true</AllowOverwrite>

<ApplyCompression>true</ApplyCompression>

</Backup>

  • For Restore:
<Restore xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>  <File>X:\SQL2008R2\SSASBACKUP\SSASDBName.abf</File>

<DatabaseName>SSASDBName</DatabaseName>

<AllowOverwrite>true</AllowOverwrite>

<DbStorageLocation xmlns=”http://schemas.microsoft.com/analysisservices/2008/engine/100/100″&gt; X:\SQL2008R2\SSASDATA\DbStorageLocation>

</Restore>

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

%d bloggers like this: