copy and restore of Sql server Analysis Service multi dimential cube

Shruti Srivastava 1 Reputation point
2021-06-24T06:30:29.57+00:00

I have a SSAS multi dimentional cube deployed in one Azure VM .I want to take backup of this Analysis service database to storage account and then want to restore from storage account to another Azure VM . How to take this backup and restore through SSMS

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,241 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-06-25T06:27:42.593+00:00

    Hi,

    As far as I know there is no such storage account in this scenario for SSAS, what do you want with this account?

    For you purpose, you could back up the SSAS database and restore it in the new SSAS server. On Azure VM it works the same as on-prem SSAS. For detail step please follow : SQL Server Analysis Services Backup and Restore

    Lukas