At times the out of sync are known to occur after a certain time. Most common cause is removal of queue data due to some system, database or replication issues. But there can be other issues resulting in out of sync after a particular time such as user error, etc. The “where” clause in Repair comes handy when fixing out of sync on very large tables that would otherwise require a long time even with means other than Repair. The only pre-requisite is that the table should have a DATE type of field that logs the creation time of a row as well the time as and when that row is subsequently updated.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center