VBR is overwriting local changes (i.e. new table etc.) once restore with backup. Can restore work in append mode?
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
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.
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
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.