Is there any way to rollback transactions in SQL Server?

Question

Yesterday I wrote some code module, that wrote wrong data in almost 400 existing records in important database on SQL Server 2008. I didn't make backup of this database (my mistake). So the question is how do I rollback these 400 transactions? Is there any way to do this? Thanks.

Manually fixing these transactions looks to be the only option, if it was yesterday then most likely you've already committed the changes. — llanato, Apr 08 '14 at 08:32

score 2 · Accepted Answer · answered Apr 08 '14 at 08:47

2

You can't rollback, but if the database is in full recovery model, then you can restore to another servar with stopat, and recover the deleted rows from there.

answered Apr 08 '14 at 08:47

dean

9,960
2
25
26

score 0 · Answer 2 · answered Apr 08 '14 at 08:31

You can roll back a transaction as long as you haven't committed it.

But if you ran it yesterday, chances are very high you did commit - and then there's no way back.

So you're options are to

either restore a backup (and next time remember to take one before such an operation!)
manually "undo" those 400 transactions

Is there any way to rollback transactions in SQL Server?

2 Answers2