VBR database restore in append mode

rajuk99

VBR is overwriting local changes (i.e. new table etc.) once restore with backup. Can restore work in append mode?

Nimmi_gupta

You can try Object restore (Restoring all Objects From an Object-Level Backup) .

Check the below vertica document for the Object Restore.

https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringObjectLevelBackups.htm?tocpath=Administrator's Guide|Backing Up and Restoring the Database|Restoring Backups|_____3

rajuk99

Thanks Nimmi, I knew about that option. Just didn't wanted to go that path of specifying each and every object in .ini file for object level backup. It would be really useful to have a command line option to restore in append mode for full backup restore activity.

mosheg

Did you try to restore individual tables and schemas from a full or object-level backup as shown in the below link?
https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringIndividualObjectsfromaFullorPartialBackup.htm