Share via

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,338 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,826 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.