Does SAP support incremental/delta backups? if so which note describes it

[former_member196032]

I'm just about to test incremental/delta backups on udb 9.5 fp1. Now to my question:

Does SAP support incrmental/delta backups?

Is there a note, I couldnt get a hit on OSS

Are there any gotcha's? such as do I need to move read only tables to a new talbespace?

Any info on this is greatly appreciated.

Anke

[former_member196032]

thank you

[paul_power]

Hi Anke,

You can specify whether you want to perform a full, incremental or incremental delta backup and the frequency via DB13 or the planning calender in DBACOCKPIT.

SAP Note 1269697 DB6: Backup Performance

should be of use to you and please also see our administration guide available at our main page

https://www.sdn.sap.com/irj/sdn/db6 under Administration. Specifically check the guide

"Data Recovery and High Availability Guide and Reference" mentioned in Chapter 8.3.5 Advanced Backup Techniques

There is not a specific SAP note relating to incremental/delta backups but they can be scheduled via DB13 and so, they are supported.

Regards,

Paul