SQLServer equivalent of Flashback

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

HiThere is always backup and restore!

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

Hi,If you have enterprise edition you can look at piecemeal restores,

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