Skip to Content

Recover one instance or one table with SAP HANA

Hello,

I have red in the KB.
Can I back up or recover individual database objects such as tables or schemata?

Backup and recovery always applies to the whole database. It is not possible to back up or recover individual database objects.

Does anybody know a solution to this limitation as I want to restore one instance but not the other instances (otherwise I lose all data) ?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 02, 2017 at 02:47 PM

    This

    instance.jpg

    Thank you

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02, 2017 at 11:06 PM

    I don't know of any way, maybe Lars knows.

    You could restore the backup on a "temp" system and then perform a binary copy of those schemas and then import those in.

    Add comment
    10|10000 characters needed characters exceeded