A coworker of mine made a copy of a personal geodatabase feature class, and deleted a subset of records from the attribute table. He was not aware that the original database was still linked to his copy, and therefore he deleted records from the original database. Is there any way to recover these records?

  • So, he made a copy of a personal geodatabase from you ? Can you just give him your original copy ? – PROBERT Nov 15 '16 at 17:13
  • No, the original copy is on our shared server. We run GIS on Citrix. – Malcolm G Nov 15 '16 at 17:22
  • So are you saying he was using SDE or personal geodatabase ? I have both on PC and Citrix. – PROBERT Nov 15 '16 at 17:26
  • The file he copied was a Personal Geodatabase Feature Class. I am not familiar with SDE. – Malcolm G Nov 15 '16 at 17:28
  • 2
    Shapefiles are an inadequate backup medium for geodata archiving form enterprise geodatabases. They corrupt most of the few datatypes they support. Use file geodatabase to prevent data loss. – Vince Nov 15 '16 at 18:50

Unfortunately there is no way to recover deleted records in file and personal geodatabases (short of filesystem backup restoration). If you have an enterprise database, you can use the backup and recovery capabilities of your database software (SQL Server, Oracle,...) to recover records.

  • There isn't any such thing as "sde format". ArcSDE is an access protocol, not a storage format. – Vince Nov 15 '16 at 19:00
  • "Enterprise geodatabase" is the type. "SDE" dissappeared at the release of 8.0. – Vince Nov 15 '16 at 21:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.