January 8, 2014 at 11:50 am
Hi,
I have a analysis service database. I'm able to backup from SSMS. But how schedule daily full backup for analysis service database? what kind of backups are supported?
Thanks
January 8, 2014 at 12:07 pm
You would need to schedule a job of type "SSAS Command" after scripting out your regular SSAS Backup task. Below link has details which might help you...
January 9, 2014 at 2:31 pm
I use this solution:
http://www.ssas-info.com/VidasMatelisBlog/27_script-to-backup-analysis-services-2005-databases
If you download the provided SSIS package and open/save it e it in 2008 R2 BIDS then you can run it in 64bit mode on SQL/Server 2008 R2 64-bit servers (with SSIS installed).
Setup a SQL Agent job (CMDEXEC) and run the SSIS Package (see the example below). This will create timestamped backup files.
This CMDEXEC example backs up a named instance of SSAS (123SSAS01T\123SSAS01T); however, just change the SSASServername.Value to specify the name of your SSAS server\instance (default or named instance of SSAS):
dtexec /FILE "F:\SSIS_Packages\SSIS_Backup\DWBackupOLAPDBs.dtsx" /SET \package.variables[BackupLocation].Value;B:\Backups\123SSAS01T\OLAP\ /SET \package.variables[SSASServerName].Value;123SSAS01T\123SSAS01T
Open a command prompt and test your commands until you get it working then schedule it with SQL/Server Agent.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply