question

AmitPatole-1684 avatar image
0 Votes"
AmitPatole-1684 asked AmitPatole-1684 commented

How to backup SSAS dB using Azure Backup?

Hi,
We are having Azure VM on which SQL server is installed. The normal dB backup using Azure Backup is working fine.
Now we want to take SSAS cube backup using Azure backup. We have searched on Azure portal not found any option for SSAS.
Please help us on this.
Thanks

azure-backup
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

To follow-up, Please let us know if you have further query on this.
Please don’t forget to Accept the answer

0 Votes 0 ·

1 Answer

learn2skills avatar image
0 Votes"
learn2skills answered AmitPatole-1684 commented

Hi @AmitPatole-1684
Thank You for posting in Q & A forum.

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.

refer this url for configuration steps - Analysis Services database backup and restore



If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Sorry for delayed response!

It is fine if I take backup on storage account, but I want to take SSAS DB backup on Recovery Service Vault.
Currently we are taking normal SQL DB backup on recovery service vault.
How I can configure the SSAS & SQL Agent Job backup on same recovery service vault?

Thanks in Advance!

0 Votes 0 ·