SQL Server Performance

Revocer Data from Delete/Update Query Mistake without 'Where' condition !!!

Discussion in 'General Developer Questions' started by yhchan2005, Jun 22, 2008.

  1. yhchan2005 Member

    Hi, i got a table which has 100,000 record and i accidentally update the record without 'Where' condition, this cause all row in this table
    was get affected. I don't put in 'Begin Tran', May i know do we have any way to recorver back the data ?
    * How about wrongly delete the record without 'where' condition, can we recorver back ?
    Thank You !
  2. moh_hassan20 New Member

    Sorry, you can(not) rollback , except you have a backup.
    if you still keep your log files, you may restore lost data
    There is a tool called "ApexSQL Log " , find in: http://www.apexsql.com/sql_tools_log.asp
    one of its features
    "wish you could UNDO that Update statement without a where clause!? ApexSQL Log is the Industry's most powerful recovery options for SQL Server 2005. We've helped customers recover single statements to 350 GB databases! No backups required." [:D]

Share This Page