Consistent Schema backup

[sumanthota2014]

hi

Is there way to create a consistent copy of the schema backup?
I tried creating one with vbr.py, and the backup is successful. However if I drop the table in the database, the schema backup is not useful. I believe the table is getting dropped from backup as well.. How to get a consistent backup so that I can restore it back to the original state after any kind of testing...

[NorbertKrupa]

If you run a full backup with some table, then drop it, the table is still part of the backup until you take another backup (incremental or full). You can also do object level backups and restore even if the target table doesn't exist.

You can try using snapshots as well.