The Vertica Database Forums

Hi,
I am new to Vertica.

As a DBA, I have incorporated script to enable retention of partitions using Unix script. It worked fine till end of 2017. In the NewYear, it went wrong. Unfortunately, it picked up wrong date and dropped all partitions prior to that date.

Its been a day now, not able to find option to recover the dropped data.
Could some one let me know how to proceed in recovering the dropped data.

Regards
Prasad

Hi,

Dropping a partition is permanent action and there is no way to roll it back. Do you have a recent backup? You can restore the table from it.

See:
https://my.vertica.com/docs/9.0.x/HTML/ ... Backup.htm

In the future, maybe look into archiving partitions as opposed to dropping them? Archived partitioned can be restored.

See:
https://my.vertica.com/docs/9.0.x/HTML/ ... itions.htm