Sunday, February 12, 2012

Best Way To Find Deleted Records

Due to a programmer's error, a few records were deleted from one of our
databases. What is the best way to discover which records were deleted?
Is there any easy to parse the logfiles for this information?
--
Will
westes AT earthbroadcast.comWill,
http://www.lumigent.com/products/ They sell the Log Explorer product which
can read the logs and produce the needed T-SQL to reinsert the data. You
and I don't have the information to do it ourselves. (There is another
product or two out there as well.)
If you have space to restore your last backup (assuming it holds the missing
records) to another database, e.g. "MyDatabase_EMERGENCY", then you can do a
compare between the tables in MyDatabase and MyDatabase_EMERGENCY.
Russell Fields
"CHANGE USERNAME TO westes" <DELETE_westes@.earthbroadcast.com> wrote in
message news:uzC9D3weEHA.3988@.tk2msftngp13.phx.gbl...
> Due to a programmer's error, a few records were deleted from one of our
> databases. What is the best way to discover which records were deleted?
> Is there any easy to parse the logfiles for this information?
> --
> Will
> westes AT earthbroadcast.com
>

No comments:

Post a Comment