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?
[GIS] How to recover deleted records from a geodatabase
arcgis-10.3arcgis-desktopfile-geodatabase
Related Solutions
You have a few possible options and they all depend on your specific environment and set-up. First, if you have versioning turned on for the feature classes in question and you have not reconciled and posted all of the versions, you could connect to (or have another user connect to) the database with a different version that the edits were not made in and that has not been reconciled and posted since the bad edits, and they should still see the features. You could then export those features, connect back to your version, and append those features back in. Additionally, if the only edits you made in your edit version were the mistaken edits and you have not reconciled and posted them yet, you could always just get your database administrator to delete your edit version from the database and re-create it, effectively removing all of the mistaken edits. And there are some other options with versioning such as having another user edit the same features and using reconcile and post settings very carefully (by row not attribute for example) and reviewing conflicts and resolving as desired to retain the features. More on versioning http://desktop.arcgis.com/en/arcmap/10.3/manage-data/geodatabases/an-overview-of-versioning.htm
If versioning solution is not an option, perhaps you have archiving turned on for the datasets in question. If so, it is as simple as connecting to the database using a historic version time prior to when the bad edits were made. Then you can select those features, export them, connect back to the live dataset, and append in those features. More on Archiving http://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/geodatabase-archiving.htm
Next, if it is an enterprise database, that means you are using some sort of database management system, such as Microsoft SQL Server, Oracle, PostgreSQL, etc. And most of those systems have various back-up procedures and options. If you had your system set up to run some database backup, you should be able to restore a backup of the database, either over-writing the current database and returning it to a backup before the bad edits were made, or restore the backup to a new database you can connect to and extract the features in question out of and then append them back into the live database.
Finally, depending on your situation, it may be worth looking through (and/or having other users look through) some of their analysis work they may have done with those datasets. For another, unrelated, prior project you or someone else may have run a clip geoprocessing tool (just for example) against the dataset(s) in question, covering some or all of the features in question, and the output of that tool may be in some project specific file geodatabase on your system somewhere. If so, you should be able to go into that dataset and again, get the features and copy/paste or append them into the main live datasets.
Again, these procedures will vary depending on your local set-up. So use with care (and if none of them work, look into setting up some of the mentioned options so you can handle similar situations in the future).
Best Answer
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.