how to use flashback in sql ?

Posted by Yugandhar under Sql Server on 9/5/2012 | Points: 10 | Views : 3212 | Status : [Member] | Replies : 2
how to use flashback in sql ?
plz provide syntax
and example




Responses

Posted by: Hariinakoti on: 9/5/2012 [Member] Starter | Points: 25

Up
0
Down
Hi Yugandhar,
see this below link
http://www.oracle-developer.net/display.php?id=313

Thanks & Regards
Hari

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 9/5/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
We don't have any direct option in SQL Server

But, we can use either one of the following options

1. You can use Database snapshot and Identify the changes since the snapshot was created.

2. You can use CDC (Change Data Capture) in SQL Server 2008

3. You can use FN_DBLOG(NULL,NULL) to read Log records until shrink/clear the transactions

4. You can use Tracing Trigger and track the changes

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Yugandhar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response