Sunday, February 26, 2012

Get row timestamp with no timestamp column

For starters, please feel free to move this if it is in the wrong forum.

The issue I have is this. I have been asked to delete all information from a table that was inserted before May 12 this year. The issue is that when the DB was created, whoever designedd it neglected to add a timestamp column for the user data table (the one I need to purge). Does SQL, by default, happen to store insert times? Would it be something that might hide ina log file somewhere?

Your best bet is to try and find a backup from May 12th or 13th, and restoring it into a new DB. Then you can compare the two, and only keep the newer rows. However, this won't address if any of the fields were updated in the interim.

|||Great Idea! I unfortunately only have access through query analyzer right now, though....|||turns out i cant get access to the server itself, and they only keep backups back 5 days, so no dice.... Any other suggestions?

No comments:

Post a Comment