Think that says it all?
Now that it has MVCC it's really surprising that it doesn't.
Stephanie Page
2010-10-18 21:20:05
+1
A:
Closest equivalent is probably Database Snapshots. You can create a database snapshot at the moment of interest and then report against the snapshot. Unlike flashbacks, the moments at which the SQL Server snapshots are taken has to be pre-determined.
Remus Rusanu
2009-08-10 23:43:28
A:
If you are backing up your transaction logs and database (as you should be if your system is highly transactional) you can recover to a point in time which as I understand it is what a flashback query is. Look up the restore statement in books online and look for the discussion of point in time.
HLGEM
2009-08-11 19:50:48
No, that's not close. Flashback Query is literally a SQL statement with an "AS OF" clause. Show me the list of users "AS OF" last Tuesday. Simultaneously, you could run the same query AS OF Yesterday. Point in time recovery means down time and means the whole database is set to as of that time.
Stephanie Page
2010-09-14 16:31:23