Post reply

Delete query data recovery

  • January 28, 2011 at 6:41 am

    #230914

    Hi Friends,

    I am having two tables that are likely same name and unfortunately i have run a simple

    delete command for wrong table name.

    Now

    i need to recovere all importent data is there any way to get all the table data again after execute

    delete query?

    solve if possible its urgent data in that table.

  • January 28, 2011 at 6:46 am

    #1279672

    Do you have a backup of the database, taken before the deletion?

    BrainDonor

    Steve Hall
    Linkedin
    Blog Site

  • January 28, 2011 at 6:53 am

    #1279675

    Restore from a backup from before the delete. If the DB is in full recovery and you have log backups you can restore to a new database and to just before the delete occurred and copy the data over.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 28, 2011 at 6:58 am

    #1279680

    The short answer is "no" you cannot easily recover this.

    If you want to spend money on a tool like ApexSQL Log, they can read the transaction log and give you scripts to recover the data, but there isn't another good way to perform the recovery yourself, except what has been suggested above.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • January 28, 2011 at 9:18 am

    #1279764

    Next time, before you delete records from an important table, back up the table and/or archive the records that will be deleted.

  • January 29, 2011 at 1:16 am

    #1280054

    Thanks Your solution is best for me...:-)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply