Does anyone know if SQL Server has a way to query data as of a point in time similar to Oracle's flashback query? If you aren't familiar with it, flashback query ability allows you to execute a normal select statement with an additional AS OF clause before the where clause to indicate a point in time. This functionality utilizes undo retention and data is only available based on the settings of the undo retention and tablespace restrictions.
Example of Oracle's flashback query:
SELECT * FROM MYTABLE AS OF TIMESTAMP (SYSDATE - INTERVAL '30' MINUTE);
The only way I can think of doing this in SQL Server is by restoring the database to that point in time, and then querying. Not really the answer you're looking for...
If you want to do this, though, when doing the
answered Jul 10, 2015 at 08:16 AM