Is there a way to roll back a database to specific time?

Question

Hi all, I'm working with an enterprise database (.sde) and was wondering if there's a way to roll it back to a specific place in time to view features that were there under each of the datasets?

thanks George

George_Thompson · Answer

Just to be clear, if you enable archiving now it will NOT have the edits from the past.

GeorgeJones9272 · Answer

Ok will give it a shot. thanks!

George_Thompson · Answer

If you had archiving on the feature class that may be possible: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/what-is-archiving-.htm

For the entire enterprise geodatabase, that is more difficult. If you roll back (restore) to point in the past, it will roll back everything.

If you have a backup from that time period, you may be able to restore to another instance of your RDBMS and look there. A lot would depend on your backups and the RDBMS that you are using.