Link to home
Start Free TrialLog in
Avatar of ramadadi
ramadadi

asked on

how to rollback update statement in sql server 2005

Hi Experts,

I have updated one table coumn, with out where clause, it has updated all the column data withe the same value.
ex. update <table> set Column1 = 'Abc'

is there any way to get the previous data, before updating table, i am not using transactions.
Avatar of Aneesh
Aneesh
Flag of Canada image

Hello ramadadi,

you can either restore the backup of the database or use tool like Lumigent Log explorer to revert the changes


Regards,

Aneesh
ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India 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