October 5, 2010 at 11:44 am
I am just learning the ropes with AS administration. We have an application that loads a series of files into a Relational DB and then updates an OLAP cube (MOLAP).
I have Full recovery in place on the SQL DBs with hourly transaction log backups. I intended to do a daily backup of the AS database after the cube has been updated.
We are just implementing the system and want to test recoverability. How important is it that the relational backup and AS backup be synchronized?
In other words, let's say that we have a Tue 11am backup of the AS database and also a Wed 11am backup. We decide to restore the SQL DB to a Wed 6am point in time and reload the data files. Do we need to also restore the Tue 11am AS backup?
October 5, 2010 at 10:29 pm
Hi,
It depends on your cube processing strategy. There are two types of processing strategy:
1) Process full
2) Process incremental
If it is Process full then no issues, AS DB will be created from scratch. but if it is incremental approach then you need to take Tue 11AM backup to put new changes.
Thanks,
Amit G
http://www.msbiconcepts.com
October 6, 2010 at 7:13 am
It is an incremental update. Thanks for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply