SSAS Scripts 
SSIS package to backup all Analysis Services databases on one instance
SSIS package to backup all Analysis Services databases on one instance
| SSIS package to backup all Analysis Services databases on one instance |
| Written by Vidas Matelis | |||
| Tuesday, 17 July 2007 19:51 | |||
|
Here is SSIS packaga that creates backup for each database in one SSAS instance. You can specify backup folder and server name by passing SSIS package variables through command line:
Use it at your own risk.
|
Tags: backup, script, ssis
Comments (1)
1
Sunday, 30 March 2008 00:18
Brian
Thanks for the Backup Script.
Most read
- SSIS Package to process all dimensions in one SSAS Database
- SSIS package to backup all Analysis Services databases on one instance
- SSIS Package to Back Up SSAS Databases by Dave Fackler
- SSIS Package to drop and create partitions based on data in SQL Server table
- WSH script to get SSAS DB info about aggregation designs
Top Rated
- PowerShell script to list info about SSAS databases
- PowerShell script to process all dimensions and cubes in one DB limiting workload
- WSH script to get SSAS DB info about aggregation designs
- SSIS Package to drop and create partitions based on data in SQL Server table
- SSIS Package to Back Up SSAS Databases by Dave Fackler
- Killing sessions automatically with SSIS
- Teaser: SSAS Cache Warming with PowerShell
- PowerShell script to process all dimensions in one Analysis Services database
