Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

Undo an Update Query

Hi Experts,
I have done this thing second time in my life. Ran an Update query without a Where clause!

I have no DB backup. What are my options?

Its SQL Server 2008.
0
CodeCruiser
Asked:
CodeCruiser
  • 5
  • 4
  • 3
  • +4
6 Solutions
 
RiteshShahCommented:
you can't do anything unless you have full backup or transaction log backup.
0
 
CodeCruiserAuthor Commented:
I have seen some articles showing the use of utilities like Log Explorer to undo selective queries from the log files but its not installing for me.
0
 
Lee SavidgeCommented:
If you put a begin tran before it you can rollback the transaction. If not, without backups you're a bit up the creek without a paddle I'm afraid. I've done it myself and you get that cold sweat moment.

Lee
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
dhlotterCommented:
hi,

try SQL Log Rescue (http://www.red-gate.com/products/SQL_Log_Rescue/)

it is free and can quite possibly do what you need to be done.
0
 
CodeCruiserAuthor Commented:
Tried the Log Rescue. Installs ok but never connects with always saying the server component not installed.
0
 
Lee SavidgeCommented:
Log Rescue is for SQL 2000 only. Doesn't support 2005 or 2008 since Microsoft altered the log format.

Lee
0
 
dhlotterCommented:
apologies, missed the part where you said SQL 2008
0
 
RiteshShahCommented:
as I told you in very first post that without backups, you can't do anything.
0
 
CodeCruiserAuthor Commented:
Does it mean that there is no such tool as Log Explorer or Log Rescue which works with SQL Server 2008?
0
 
Lee SavidgeCommented:
0
 
inikolicCommented:
Or try APEX SQL Log viewer
0
 
inikolicCommented:
0
 
PrakashRaoBSCommented:
Try Apex SQL Log. Luminent Log Explorer has been acquired by Apex SQL now. So you can try the Apex SQL Log. It supports all SQL Server versions/editions including 2000, 2005, 2008, 2008 R2, x86, x64 and IA64.

http://www.apexsql.com/sql_tools_log.aspx
0
 
CodeCruiserAuthor Commented:
As I said earlier, I have been trying the Apex SQL Log. I tried all methods including installing client on client computer and server on server computer, installing both on client computer, and installing both on server computer but in all cases when i try to use it says server components are not installed properly.

One thing I noticed is that it ran *Uninstall*.sql when installing and also ran this when uninstalling so may be a problem with their installer!
0
 
inikolicCommented:
You haven't mentioned you've tried Apex.

Anyway, what recovery model is set on your database?
(http://msdn.microsoft.com/en-us/library/ms189272.aspx)

If your recovery model is Simple then nothing is backed up in your transaction log.

If its full, try using methods described in:
http://searchsqlserver.techtarget.com/tip/How-to-restore-from-a-transaction-log-in-SQL-Server?ShortReg=1&mboxConv=searchSQLServer_RegActivate_Submit&

Btw, I'm in similar situation an hour ago I've dropped all UDFs from development machine instead
from deployment machine where I wanted to transfer those new I've been programming for last
two days.


Br
Ivan
0
 
inikolicCommented:
What I've discovered is, at least (and even with Simple recovery model on), that
you might find out what objects (and when) have been altered which might be
helpful with a damage assessment.

By executing custom reports on your SQL Server Logs.
Standard set of custom reports (*.RDL files) may be found at:
http://blogs.msdn.com/b/sqlrem/archive/2006/08/30/ssms-reports-3.aspx
direct link:  http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Components-PostAttachments/00-00-73-29-10/SSMS-Standard-Reports.zip

While some guidelines of how to create your own custom report may be found at:
http://blogs.msdn.com/b/sqlrem/archive/2006/11/20/custom-reports-in-management-studio.aspx


Good luck,
Ivan
0
 
Rajkumar GsSoftware EngineerCommented:
Did you try 'ApexSQL Recover' as well ?
http://www.apexsql.com/sql_tools_recover.aspx
http://www.apexsql.com/datasheets/New_Recover2008_Detailed.pdf

I am not sure about this tool. Just a google result.

Raj
0
 
CodeCruiserAuthor Commented:
Had to do the data entry again. Thank you all for trying to help.
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 5
  • 4
  • 3
  • +4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now