Skip to Content
0

Recover one instance or one table with SAP HANA

Feb 28, 2017 at 09:13 AM

282

avatar image

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

10 |10000 characters needed characters left characters exceeded

What do you refer to as "instances"?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Patrice VIGIER Mar 02, 2017 at 02:47 PM
0

This

instance.jpg

Thank you


instance.jpg (130.9 kB)
Share
10 |10000 characters needed characters left characters exceeded
Jimmy Yang
Mar 02, 2017 at 11:06 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Well, he doesn't answer to my question, so I don't really know what he is asking... (doesn't seem to be urgent).

0