topic Re: Is there a way to roll back a database to specific time? in Data Management Questions

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

GeorgeJones9272 — Fri, 31 Jan 2025 12:12:42 GMT

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

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

George_Thompson — Fri, 31 Jan 2025 12:23:34 GMT

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.

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

GeorgeJones9272 — Fri, 31 Jan 2025 16:25:29 GMT

Ok will give it a shot. thanks!

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

George_Thompson — Fri, 31 Jan 2025 17:12:53 GMT

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