CODEWITHSUNDEEP
sql-server
İsmet Alkan
İsmet Alkan

Reputation: 5447

Rollback Update Operation in SQL Server

I executed an UPDATE operation for every row in my table by mistake. Is there any way I can take this back? I use SQL Server 2005.

Upvotes: 1

Views: 249

Answers (1)

vhadalgi
vhadalgi

Reputation: 7189

I recently ran into same situation but latter used this third party tool and it worked !

http://www.apexsql.com/sql_tools_log.aspx

Read this thread it might help

And.. If you have already executed the update query and want to roll back,your only real option is to restore a database backup.

If you are using Full backups, then you should be able to restore the database to a specific point in time.

Upvotes: 1

Related Questions