Loading

how to rollback last update sql query i did

mohammed shamsheer

12y1.4k

Its very urgent for me.....

update ProductSerial set BranchID=2 where BranchID=4 and ActivatedSystems=0 and CustomerID=1 and ProductID=19

this is the query i have to run.....instead of that i did..

update ProductSerial set BranchID=2

it my online db.....i have to recover it from previous stage....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

mohammed shamsheer12y ago
i backup my db.....and used it with apexsql but it is has no result ...if we back up sql log files also backuped...
0
mohammed shamsheer12y ago
Thank u jaganathan ....my one is online db.....it have high security....the tool is not working...
0
Jaganathan Bantheswaran12y ago
Hi,

Here is the Way with SQL management Studio.

Or

You can do with ApexSQL tool.

Here is the nice post which explains how to do so...
0