August 25, 2011 at 2:13 pm
I am new to manage this SSAS server, we have all backup jobs for all source databases, do we need backup job for those SSAS databases ? I think they could gerenate from those SSIS jobs , no ? Why we need to backup those SSAS databases ? Any advice/recommandation will be appreicated , thanks.
ddfg
August 25, 2011 at 4:30 pm
It may faster to restore a backup than to rebuild it, but I've never tested it with a large database. I just always figured that it couldn't hurt to back up SSAS databases as I would any other SQL Server database.
August 25, 2011 at 5:56 pm
Like most things in SQL Server the answer is It depends
What would happen if all the data currently in an SSAS database could not be accessed since unknown to yourself it was deleted from some of the source DBs ... and your managers needed that information.
The "It depends" factor rears its ugly head ... If you have your resume up to date and have interviewed for a new job... well maybe you don't need backups.
Backups can not hurt .. better to have them for restoring if necessary, rather than be unemployed, and on the opposite side of the coin, if it is necessary to restore from a backup you will be "hailed" as a hero, one who obviously can plan for the unexpected.. a valued employee.
August 25, 2011 at 6:16 pm
It is just my experience that I cannot support by any quotes of authoritative materials, but I would back up only partitioned cubes if I can restore just the partition that was hit. Otherwise it tends to be waste of CPU capacity and time.
In other words, if the cube is so small that it does not have to be partitioned, it is usually easier to rebuild it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply