Solved

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

Posted on 2003-11-12
10
329 Views
Last Modified: 2012-08-14
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
0
Comment
Question by:HenningF
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 17

Expert Comment

by:Squeebee
ID: 9735907
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
 
LVL 1

Author Comment

by:HenningF
ID: 9735920
Heh, I'm afraid it has to be the a restore of some sort...
0
 
LVL 17

Expert Comment

by:Squeebee
ID: 9736052
Then you will have to restore your backup and replay your logs.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 1

Author Comment

by:HenningF
ID: 9736069
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
 
LVL 17

Expert Comment

by:Squeebee
ID: 9736266
Actually I don't use MSSQL, but I am sure someone will give you the steps.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9736441
Please maintain this old open question:

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

Thanks,
Anthony
0
 
LVL 39

Expert Comment

by:appari
ID: 9737645
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
 
LVL 1

Author Comment

by:HenningF
ID: 9739494
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9740002
>>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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 9742162
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question