tool for restoring sql data after accidental deletion

Forum Moderators: open

Message Too Old, No Replies

tool for restoring sql data after accidental deletion

job_ppa

3:44 pm on Jul 15, 2010 (gmt 0)

Hi.

We are using sql server 2005 and accidentally deleted table rows from database. We tried restoring .mdf/,ldf files from last night backups but these files are not getting backed up because they are constantly in use.

Is their any open source tool available i can use to restore these deleted rows in a table?

LifeinAsia

3:54 pm on Jul 15, 2010 (gmt 0)

You should be doing a SQL backup, then making a backup of that backup file. If you haven't been doing that, there's little chance of recovering your data.

Depending how you have your DB setup, you *might* be able to recover by rolling back changes from the log file. But it may be too late at this point. I don't know of any open source tool for that. A DBA with more experience than I have may be able to do something.