If a database administrator restores the server database from a backup, the UpdateRestoreDate.sql script must be run to update specific fields. This is necessary because clients normally synchronize with the server in a way that only uploads or downloads the latest changes that occurred after the last synchronization. This is a differential or incremental update. This works because the server and the client assume that the time can only go in one direction: ahead, but cannot go back. This rule is violated when the server database is restored to an earlier point in time. Therefore, a special flag must be updated in the database which indicates that an incremental refresh would not work, but a full refresh is needed, because the server “went back in time”. The system cannot normally handle this situation correctly, unless the script is run.
The UpdateRestoreDate.sql script is located in the Utils folder in the location where the Developer server is installed.