Skip to content

Latest commit

 

History

History
106 lines (60 loc) · 4.38 KB

analysis-services-backup.md

File metadata and controls

106 lines (60 loc) · 4.38 KB
title description author manager ms.service ms.topic ms.date ms.author ms.reviewer
Azure Analysis Services database backup and restore | Microsoft Docs
Describes how to backup and restore an Azure Analysis Services database.
minewiskan
kfile
azure-analysis-services
conceptual
10/18/2018
owend
minewiskan

Backup and restore

Backing up tabular model databases in Azure Analysis Services is much the same as for on-premises Analysis Services. The primary difference is where you store your backup files. Backup files must be saved to a container in an Azure storage account. You can use a storage account and container you already have, or they can be created when configuring storage settings for your server.

Note

Creating a storage account can result in a new billable service. To learn more, see Azure Storage Pricing.

Backups are saved with an abf extension. For in-memory tabular models, both model data and metadata are stored. For DirectQuery tabular models, only model metadata is stored. Backups can be compressed and encrypted, depending on the options you choose.

Configure storage settings

Before backing up, you need to configure storage settings for your server.

To configure storage settings

  1. In Azure portal > Settings, click Backup.

    Backups in Settings

  2. Click Enabled, then click Storage Settings.

    Enable

  3. Select your storage account or create a new one.

  4. Select a container or create a new one.

    Select container

  5. Save your backup settings.

    Save backup settings

Backup

To backup by using SSMS

  1. In SSMS, right-click a database > Back Up.

  2. In Backup Database > Backup file, click Browse.

  3. In the Save file as dialog, verify the folder path, and then type a name for the backup file.

  4. In the Backup Database dialog, select options.

    Allow file overwrite - Select this option to overwrite backup files of the same name. If this option is not selected, the file you are saving cannot have the same name as a file that already exists in the same location.

    Apply compression - Select this option to compress the backup file. Compressed backup files save disk space, but require slightly higher CPU utilization.

    Encrypt backup file - Select this option to encrypt the backup file. This option requires a user-supplied password to secure the backup file. The password prevents reading of the backup data any other means than a restore operation. If you choose to encrypt backups, store the password in a safe location.

  5. Click OK to create and save the backup file.

PowerShell

Use Backup-ASDatabase cmdlet.

Restore

When restoring, your backup file must be in the storage account you've configured for your server. If you need to move a backup file from an on-premises location to your storage account, use Microsoft Azure Storage Explorer or the AzCopy command-line utility.

Note

If you're restoring from an on-premises server, you must remove all the domain users from the model's roles and add them back to the roles as Azure Active Directory users.

To restore by using SSMS

  1. In SSMS, right-click a database > Restore.

  2. In the Backup Database dialog, in Backup file, click Browse.

  3. In the Locate Database Files dialog, select the file you want to restore.

  4. In Restore database, select the database.

  5. Specify options. Security options must match the backup options you used when backing up.

PowerShell

Use Restore-ASDatabase cmdlet.

Related information

Azure storage accounts
High availability
Manage Azure Analysis Services