Link to home
Start Free TrialLog in
Avatar of suwanee
suwanee

asked on

Accidently update a table, How can I recover??

Hi, Guru,

I accidently update the wrong rows of one table in the MS SQL server through Query Analyzer. How can I recover the old result? Somebody said the "ROLLBACK". But it gave me the error: "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION."

I am new on the Database, how can I recover the old result? Thanks.

ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
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
Avatar of suwanee
suwanee

ASKER

No, I don't have backup, and I don't know the old results. It got to be a problem.
You may be hosed here.  Can you re-import the table from whatever the source of its data was?

Sorry.
-Jim
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
On the bright side, you may have your first really good example of "Why we must do backups". If you cant recover the data you may want to keep a record of this incident to refer to whenever you are getting a bit lazy on the backup front, or when someone tells you that you dont really need backups.

Cheers
SFH
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
I think Jim and Jrb both supplied pertinent answers given the information they had at the time. I feel my advice is just as applicable as julians, given that by the time julian answered we knew that the transaction had not been declared. For future use, my advice on backups is just as if not more useful than transaction rollback syntax.