SQLServer equivalent of Flashback
in [Programming SQL]
|
Prev: Theoretical question about index fragmentation in filegroup partitions
Next: How to increment a column with varchar data type
From: Abba on 23 Feb 2010 01:14 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
From: jbellnewsposts on 23 Feb 2010 02:43 On Tue, 23 Feb 2010 11:44:36 +0530, "Abba" <sql_help(a)aaa.com> wrote: >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 > 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
From: jgurgul on 23 Feb 2010 03:21
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 "Abba" wrote: > 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 > > > . > |