question

alhowarthWF avatar image
0 Votes"
alhowarthWF asked ·

Backup all SSAS databases via a script

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
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

2 Answers

alhowarthWF avatar image
0 Votes"
alhowarthWF answered ·

Although I had previously searched for a solution, I ran across this one today.

backup-analysis-services-database-using.html


·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered ·

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

·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

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