DB config Restore Backup

Question: Error when running ConfigDB: "Tables exist that have not had their backup data restored. You must run restorefrombackup before you configure the database" But there are no backup tables to be restored. ???

Answer: This can happen if a table is manually restored via SQL rather than using restorefrombackup. A flag is left in the database that indicates restorefrombackup needs to run to restore the data from the xxtable_name to table_name.

To correct this you need to remove these flags from the database. To verify if these are incorrect run the following query.

select restoredata from maxtable where tablename='table_name'

select restoredata from maxtablecfg where tablename='table_name'

If either of these return a value of 1 they must be changed to 0 to allow ConfigDB to run.