rollback a query analyzer task

[hamzajosh]

I wanted to update one field in a table of a particular row. i said
update "table" set "field" = "value" without putting the where clause. Damn stupid of me. It changed all the "field" to "value" in the whole table.
Is there any way i can rollback this statement to get the original values back for this field in the table?
Any help would be appreciated. BTW i do a weekly full backup of the database and daily incremental backup. I just want to restore this table and not any other tables. If i need to do restore, then how do i restore only this one table? Ideal would be not needing a restore Thanks


Learn everything but implement only what is needed.

 

[ClaireHCM]

No you cant restore partial of the backup file. "Lumigent" Log explorer is the resolution in this situation.

 

[hamzajosh]

What is "lumigent" log explorer?

Learn everything but implement only what is needed.

 

[ClaireHCM]

check this site out

http://www.sql-server-performance.com/log_explorer_spotlight.asp

and

http://www.lumigent.com/