Share via

Backup all SSAS databases via a script

alhowarthWF 301 Reputation points
2021-03-02T15:19:15.437+00:00

I just added SSAS 2017 tabular instances. Does anyone have a script that looks for all databases and creates backups?
I know how to to script out each one, but would like to automate this so I don't have to look for new databases.

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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-03-03T03:08:33.3+00:00

    Thanks for sharing your experience ! :)
    The PowerShell script should work well for the automation .

    0 comments

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.