Backup all SSAS databases via a script

alhowarthWF 276 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,240 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 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 No comments