Flashback query equavalant in Sql server

_{Wednesday, May 26, 2010 3:21 PM}

Hi All,

Do we have some kind of option to pull history of data changes happened to particular table in Sql server? In oracle Flashback query option will be usefull to identify datachanges happened in particular time.

Do we have something like that in Sql server 2005. Any reply would be greatly appreciated

Thanks, Sengwa

_{Wednesday, May 26, 2010 4:46 PM ✅Answered}

You could create a Database Snapshot on the database and then use that to find out what changes have happened on the database since the snapshot was created. You can also restore the database to a previous state using the snapshot.

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

If you are using SQL Server 2008, then you can use Change Data Capture to monitor the insert/update/delete activity on the table that is being monitored by CDC.

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

HTH

This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: http://troubleshootingsql.wordpress.com
Twitter: @banerjeeamit
SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq

_{Monday, June 7, 2010 1:37 PM}

Hi All,

Thanks for your responses. Really apreciate it.

Thanks, Sengwa