SUPERURGENT!! Updated 500 rows in prod database accidentally. 500 points

I accidentally updated 500 rows in my production database without the possibility of a rollback. I do however have the translogs and I have closed my website so that no other transactions can be made.

I need to undo my update fast as hell, can anyone please help me??? I do know that I should have practised this ages ago but you know how it is...

HenningF
LVL 1
HenningFAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SqueebeeCommented:
I don't suppose this update was something transformal like SET salary = salary * 5; ?? If so just do the opposite. If not then you need to go to your last backup, restore it, then replay the logs up to the massive UPDATE statement.
HenningFAuthor Commented:
Heh, I'm afraid it has to be the a restore of some sort...
SqueebeeCommented:
Then you will have to restore your backup and replay your logs.
Active Protection takes the fight to cryptojacking

While there were several headline-grabbing ransomware attacks during in 2017, another big threat started appearing at the same time that didn’t get the same coverage – illicit cryptomining.

HenningFAuthor Commented:
Any pointers in doing so? I have a full daily backup and translogbackup every 3 hours. I would like to restore up to my crucial UPDATE-statement. Code would be nice...
SqueebeeCommented:
Actually I don't use MSSQL, but I am sure someone will give you the steps.
Anthony PerkinsCommented:
Please maintain this old open question:

http://www.experts-exchange.com/Web/Web_Servers/IIS/Q_20681696.html

Thanks,
Anthony
appariCommented:
if you have full db back up and transaction log backup every 3 hours then go through this article on MSDN and follow the recovery plan.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_565v.asp?frame=true
HenningFAuthor Commented:
Allright, thanx fellas...no offence but I managed without our help. The tsql I used is enclosed at the bottom. Now for you to make any points maybe you could help me with this:

I had some transactions beeing completed *after* the point of failure that I had to manually put in the database after the restore was completed. Now this was a total pain in the a** and I would really like to avoid that in the future since it leaves alot of room for errors. Do you guys know how to restore portions of a logfile AFTER a certain point in time?

HenningF

------------------------------------------------------------------------------------------------

USE Master
GO

RESTORE DATABASE xxx FROM
DISK = N'D:\Microsoft SQL Server\MSSQL\BACKUP\xxx_db_200311120300.BAK'
WITH NORECOVERY

RESTORE LOG xxx FROM
DISK = N'D:\Microsoft SQL Server\MSSQL\BACKUP\xxx_tlog_200311120300.TRN'
WITH NORECOVERY

RESTORE LOG xxx FROM
DISK = N'D:\Microsoft SQL Server\MSSQL\BACKUP\xxx_tlog_200311130000.TRN'
WITH RECOVERY,
STOPAT='2003-11-12 22:50:00'

GO
Anthony PerkinsCommented:
>>Allright, thanx fellas...no offence but I managed without our help. <<
Than please go ahead and close this question. See here for help:
I answered my question myself. What do I do?
http://www.experts-exchange.com/help/closing.jsp#4

Thanks,
Anthony
moduloCommented:
A request has been made in Community Support to close this question:

http://www.experts-exchange.com/Community_Support/Q_20796975.html

PAQ-ing the question and refunding 500 points

Experts please leave any comment here when you disagree.

modulo

Community Support Moderator
Experts Exchange

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.