PowerShell Cubed: Backing up and Restoring Analysis Services Cubes w/ PowerShell
Details
Join Matthew Anderson (https://twitter.com/matholamew) for some PowerShell fun on Backing up and Restoring Analysis Services Cubes w/ PowerShell
Abstract:
Did you know that the SqlServer module, includes everything that you need to backup, restore, and many other things of SQL Analysis Services cubes?
Far too often I have seen talks about using PowerShell to backup and restore SQL Server databases with PowerShell. I have also seen some of these include some talks about SQL Reporting Services, but I have not seen one talk about how to do this with SQL Analysis Services. What I haven’t seen is the same talks about AS cubes. This is NOT a talk about what AS is or how to build a new cube. This is a talk about AS management from the perspective of a DBA. We’ll talk about different ways to perform a backup and ways to perform a restore with PowerShell.
