| 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.
|
Comments (3)
Most read
- Script to automate SSAS partition management (SQL + SSIS)
- PowerShell script to process all dimensions and cubes in one DB limiting workload
- SSIS package to backup all Analysis Services databases on one instance
- SSIS Package to process all dimensions in one SSAS Database
- SSIS Package to drop and create partitions based on data in SQL Server table
NOTE:
The script in the package doesn't seem to work on a 64-bit 2005 SSAS instance but there is a solution: Run the package in 32-bit mode ("C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /FILE "D:\SSIS\Packages\BackupAllOLAPDBs.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E)
Also note that you cannot simply use the /x86 switch (which is the same as enabling the 32-bit option in the SQL job in SSMS 2008) in SQL Server 2005 because unlike in SQL Server 2008 there are 2 separate DTEXEC commands --one each for 32-bit and 64-bit. In SQL Server 2008 there is only one DTEXEC and it takes the /x86 switch, which makes the package execute in 32-bit context.