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.
ramadadiAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
Ramadadi,

Sorry to say but there is no direct way to do so in SQL Server. What you will have to do is, restore full last backup and restore transaction log backup till the time you have updated your table. if you don't have full backup and transaction log backup than the only way is to read your log file (.LDF) which you can't do it by your own. You have to have some third party tools. may be red-gate tool can help you.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hello ramadadi,

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


Regards,

Aneesh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.