September 17, 2009 at 12:23 pm
Is there a difference in backing up a analysis cube ?database? versus rather than performing standard db backups? If so, how does one perform versioning of cubes to have copies prior to making changes?
Example scenario, So I add new dimenions and/or a a fact table to my cube and process the changes via BIDS. Later I found i made a mistake and want to back out my changes. I would like to have backup or previous version of the cube to restore from. Can anyone advise?
September 17, 2009 at 1:17 pm
Depends a little on what you mean when you say 'standard database backups'. Assuming you're referring to SQL Server DB backups, then yes, it is a distinctly different operation, but no different in difficulty (or lack thereof 😉 ). In SSMS, connect to the SSAS instance, right click on the DB you want to back up, and select, yes, "backup". To restore is basically the same process.
Steve.
September 18, 2009 at 8:27 am
Ok, thanks for your help! That is exactly what i was looking for but i do have 1 more question though? Any way to automate this like sql server backups are done? I assume this can be scrpted and placed in a job maybe? And is there a suggested standard of practice to follow on how frequently to back up? If not, then maybe just save the outputted file to in souresafe for versioning?
Thanks for your help!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply