Hi Heather
Firstly, I'd strongly suggest that you get in touch with your local support provider, and backup your database. Preserve incremental backups if possible, and take a snapshot that doesn't compromise the ability to do point in time restoration.
Regarding what the repair tool does, this is from old sde command line documentation, so it is likely to be reasonably consistent with what the geoprocessing tool does now.
The repair rules for the delta tables are as follows:
- Records in the Adds table that reference nonexistent states are deleted.
- Records in the Deletes table that reference nonexistent states are deleted.
- When multiple versions of a record are present in the same state, all but the latest record is deleted.
- When the same feature in the Adds or Base table is deleted multiple times in the same state, all but the latest delete entry is removed.
Hope the repair goes well and it solves your issue!