SSAS Articles 
Management Scripting Analysis Services Database Backup
Management Scripting Analysis Services Database Backup
| Scripting Analysis Services Database Backup |
| Written by Rob Kerr |
| Tuesday, 02 September 2008 02:49 |
|
There are a number of ways to automate backups of Analysis Services databases. Some examples I've seen: SSIS Packages, PowerShell, SQL Agent jobs with XMLA. Here is a "quick and dirty" way using a .vbs cscript that can be called form the operating system, or scheduled in SQL Agent as a cmdexec step. This script will backup all Analysis Services databases programatically (i.e. if someone adds a new database, it will automatically be backed-up without further operational changes). I'm not saying this is the best way to do this, and the script below completely lacks error trapping. But it is effective, simple to implement, and may form a good base for a robust script in your environment. Read more...
|
Tags: 2005, article, backup, powershell, script
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
