As a follow up to the work outlined in #159171, we also need to clean up the incremental location logic from features that read from backups, i.e. SHOW and RESTORE.

Jira issue: CRDB-57718