Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Rolback my Update Query

Author  Topic 

archana23
Yak Posting Veteran

89 Posts

Posted - 2013-08-07 : 14:56:53
Hi,

Instead of updating one row in table i updated all the 400 rows in table using my Update query. I forgot to add where condition in my query so ts updated all the data in table.

So how can i roll back this Update Query.

Please please help me on this? i need to do it urgently..

Thank you

Archana

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-07 : 15:00:43
You will need to restore the data unless you left your transaction open.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

archana23
Yak Posting Veteran

89 Posts

Posted - 2013-08-07 : 15:10:26
How can i take my data backuP?

Archana
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-07 : 15:24:09
You don't have a backup? If you don't have a backup from before the update, then you are out of luck.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -