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?
 
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
0
 
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.
0
 
HenningFAuthor Commented:
Heh, I'm afraid it has to be the a restore of some sort...
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
SqueebeeCommented:
Then you will have to restore your backup and replay your logs.
0
 
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...
0
 
SqueebeeCommented:
Actually I don't use MSSQL, but I am sure someone will give you the steps.
0
 
Anthony PerkinsCommented:
Please maintain this old open question:

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

Thanks,
Anthony
0
 
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
0
 
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
0
 
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.