PowerShell: Backup All SSAS Databases To A Network Share

Geschrieben von Database Magician am Freitag, 4. September 2020

'I am working on downgrading SQL Server Enterprise Edition (EE) s/w to Standard Edition (SE) where EE features are not used (to save money on licensing). We have a big list of these to go through. That required all SSAS databases to be backed-up to the network and restored after the edition downgrade. I will share the bigger script to help with the complete downgrade that includes SQL Server, SSIS, SSRS and SSAS at a later point in time.

For now, you can use the below snippet to backup all SSAS databases in an instance. Sorry, I am still using the SQLPS module instead of the newer SQLServer module but the code should be no different.'...

https://sqljana.wordpress.com/2017/09/12/powershell-backup-all-ssas-databases-to-a-network-share/