Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
agastyamahi
Starting Member
33 Posts |
Posted - 2013-12-09 : 17:12:46
|
Hi,I am creating a job that runs every day to back up an SSAS database that I have. Here is the Analysis Services Command for that<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>PipeLine</DatabaseID> </Object> <File>C:\DBBackup\PipeLine.abf</File></Backup>I don't want to overwrite my backup daily. Could any one please let me know how to add a date-stamp to my backup file.If not, I have backup-devices for each day(eg, Sunday, Monday, Tuesday etc). Is there a way I could check for the day and store the backup in the respective backup device for the dayPlease help me |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-09 : 22:25:11
|
you can do that inside SSIS. Use analysis services DDL task, form the query inside a SSIS variable by adding the date stamp value to static part by setting EvaluateAsExpression true for the variable and add a variable for it. something like"<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><Object><DatabaseID>PipeLine</DatabaseID></Object><File>" + (DT_DBDATE)GETDATE() + "</File></Backup>" ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
agastyamahi
Starting Member
33 Posts |
Posted - 2013-12-09 : 22:37:53
|
Hi Visakh,Since I want to take a backup daily this option would increase the number of files in a folder. I had actually created storage devices under server objects with names Monday, Tuesday etc. The path is present inside the storage devices. Is there a way I could back the cube database daily and put it in the storage device. Thanks |
|
|
|
|
|