Using logs to recover individual deleted records

[zephyran]

Is there a way to use rollback and/or the transaction logs to restore individual records, or parts of records, that might have been accidentally deleted or altered via Management Studio?

We are rolling out a new SQL Server 2005 infrastructure to replace an old, kludgy Advantage database to run a production line. The database is used primarily for traceability of our product. The current Advantage system has a "Show Deleted Records" function that allows us to see any records that have been recently deleted, and to Duplicate them so we can recover the data therein.

Scrapping and/or rebuilding good products is unacceptable, so in case a record is deleted by accident, we need to be able to recover that record on the fly without having to do a full restore of the entire table/database. Is this possible? How could I, as a SQL Server novice, set this up?

 

[mrdenny]

Check out Lumigent Log Explorer (

http://www.lumigent.com).

It has the ability to look into the transaction log and roll back a single transaction.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com