HANA Data backup

[former_member646800]

Hi All,

I have some questions regarding Data backup,

• If we trigger the data backup, will it take backup from Persistence level or memory level or both ?

• If from memory or both, then how it works ?

Please clarify about this concept experts.

Kind Regards,

Puneeth H A

[bharathyp · Accepted solution]

Hi Puneet,

Short answer to your question is.

No, data in-memory is not backed up. What happens is that a savepoint is created (read more on savepoints). So, once the savepoint operation is executed and the data in the memory is written to the persistence layer (data disk) that is what will be backed up.

If there are activities still going on whilst the backup is running, which is usually ofcourse the case, then when you recover you need to choose time in point recovery which will still have some slight data loss, hence in production enviroments we have HA. So, your node 2 will have ZERO data loss, yes! even in-memory data. Just choose mem-sync when you setup HA. But, that is a whole different thing.

Please go thru the link provided by Deepak and question 11 will be what you are looking for.

Best Regards,

Bharath

[former_member646800 · Accepted solution]

Hi Bharath,

Thanks for the reply.

I got your point.So it will backed up only persistence data.

Once we trigger the backup, how this backup operations works ? Means, this persistence backup will happen through memory ? Or this persistence will backed up without memory help ?

We could see sometimes memory usage will be high when backup running.In memory level,will it perform any checks while backup is running and then its backup ?

Please clarify these.

Kind Regards,

Puneeth H A