Link to home
Start Free TrialLog in
Avatar of Dangeriz
DangerizFlag for Taiwan, Province of China

asked on

Rollback DELETE!

Hi all,

I've just DELETED 19 records from a table just now in SQL Query Analyzer . How do I recover those records, or how do I roll back the transaction? What is the quickest way to recover those records?
ASKER CERTIFIED SOLUTION
Avatar of JimV_ATL
JimV_ATL

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Actually, although it may not sound right, I think that should be:

SET IMPLICIT_TRANSACTIONS ON
GO

which forces a transaction to be used, forcing you to explicitly either COMMIT or ROLLBACK.

Of course, when done, use:

SET IMPLICIT_TRANSACTIONS OFF
GO

to return to normal autocommit mode.




Avatar of xenon_je
xenon_je

Soryy to hear this, but as I see you don't have backups, so those records are lost :(
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes, I forgot the underscore in my comment!

Thanks for pointing it out, however.

====
Shiva
Scott,
Oops. I overlooked. It should've been ON instead of OFF. I believe this is what you wanted to say, right?
Dangeriz:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.