SQL Server - SQLServer equivalent of Flashback

Asked By Abba

23-Feb-10 01:14 AM

Hello,

Oracle has a feature of  'flashback' for a tablespace. This means reverting
back to a snapshot taken on a earlier date. Is there any equivalent feature
in SQLServer?  just curious....


tia,
AbbA

23-Feb-10 02:43 AM

Hi

There is always backup and restore! You can also take a snpshot and
revert to the time it was taken
http://msdn.microsoft.com/en-us/library/ms175158.aspx and there are
backup snapshots if you have the hardware support
http://msdn.microsoft.com/en-us/library/ms189548.aspx

John

23-Feb-10 03:21 AM

Hi,

If you have enterprise edition you can look at piecemeal restores, which
will enable you to recover the filegroup etc:

http://msdn.microsoft.com/en-us/library/ms177425.aspx

There is also the option of taking database snapshot, which will give you a
readonly point in time instance of the database, which you could revert to,
or copy out data from:

http://msdn.microsoft.com/en-us/library/ms175876.aspx

if you dont have enterprise then you could:

1. Use a backup to retrieve the data and copy it back in
2. Use scripts to repopulate
3. use a 3rd party tool (which could compare with another db, and script
changes. or perhaps a log reader to reconstruct lost data.)

Jon