Azure Analysis Service Tabular Model Backup

Question

All,

In SQLServer, it is easy to check if a backup happened or not by looking at the SQLServer Error Log. How do we find this info on Azure Analysis Service for a backup of a tabular model?

We need this info for compliance reason.

Thanks,
rgn

Answer 1

Hello @grajee ,

Welcome to Microsoft Q&A platform.

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.

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

Steps to configure storage settings:

1. In Azure portal > Settings, click Backup.
2. Click Enabled, then click Storage Settings.
3. Select your storage account or create a new one.
4. Select a container or create a new one.
5. Save your backup settings.

How do we find this info on Azure Analysis Service for a backup of a tabular model?

In case the backup was successful, you will see the data in the selected storage container.

In case the backup failed, you see the complete error message on the method of backup selection.

Here is created a backup using the SSMS, I’m able to see the complete information of the backup in case of failure.

For more details, refer “Analysis Services database backup and restore”.

Hope this helps. Do let us know if you any further queries.

----------------------------------------------------------------------------------------

Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.