Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

tool for restoring sql data after accidental deletion

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

New User

5+ Year Member

joined:Dec 3, 2009
votes: 0


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?
3:54 pm on July 15, 2010 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
votes: 193

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.

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members