This website is not affiliated with, sponsored by, or approved by SAP AG.

Backup ODS data

Business Warehouse

Moderators: Snowy, thx4allthefish

Backup ODS data

Postby Ryan2786 » Mon Oct 21, 2002 3:10 pm

We store historical data in our ODS. We would not be able to reproduce this data if the ODS was corrupted. For this reason, I need to keep a backup of our ODS data. One idea I have is to append the new data to a separate transparent table. I would like to know how others are making backups of their ODS data.
Thanks.
Sandy
Ryan2786
 
Posts: 36
Joined: Mon Oct 21, 2002 3:06 pm

Backup cube

Postby FCI » Thu Oct 24, 2002 3:31 am

We do regular backup of one of our infoCube using another cube with the same dimensions (except a new one which contains the date of the backup).

The backup cube is regularly load (update rules between the two cubes) and we automatically delete the older backups to keep only two in the cube (deletion routine in the infoPackage).

I presume you can do the same things for a ODS (backup from your ODS to a new one).

Hope this helps.

Regards,
FCI
FCI
 
Posts: 214
Joined: Wed Oct 23, 2002 4:45 am
Location: France


Return to Business Warehouse

Who is online

Users browsing this forum: Exabot [Bot] and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.