Teradata Database Message 1194 - 1194 - Analytics Database - Teradata Vantage

Message

%VSTR tables in the job were not enabled for Incremental Restore. Incremental Restore will not be allowed on this archive.

Explanation

There were tables in the job that were not enabled for incremental restore. When running a delta or cumulative backup with EnableBackupsforIncrementalRestore enabled on the table level, none of the tables in the job were enabled for Incremental Restore. In this case, a job level warning is displayed to inform the user that this archive will not be enabled for Incremental Restore. When running a delta or cumulative backup with EnableBackupsforIncrementalRestore enabled on the system level, some of the tables in the job were not enabled for Incremental Restore. In this case, a job level error is displayed and the job fails.

Generated By

BAR.

For Whom

End user.

Notes

This is a job level error if incremental restore is enabled for system level; otherwise, it is a job level warning message.

Remedy

If EnableBackupsforIncrementalRestore is set to system level, the user will need to run a full archive enabled for Incremental Restore. If EnableBackupsforIncrementalRestore is set to table level, this is a warning and if the user wants to use the archives for Incremental Restores, then they will need to enable objects for Incremental Restore. They can enable all objects for Incremental Restore by running a full archive enabled for Incremental Restore.