[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

SQL Server 2005 Update Query Rollback

We have a database in MS SQL Server 2005 that we connect to via ODBC-linked tables in Access 2003.  We ran an update query we did not mean to run.  Can I roll the transaction back in SQL Server, or do I need to use our full database backup from last night?  If a rollback is possible, how do I go about this?

Thanks!
0
rjander77
Asked:
rjander77
  • 4
  • 4
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
afaik, rollback is not possible after the transaction was committed.
use the backup.

i might be wrong

wait for other experts to comment
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
> If a rollback is possible, how do I go about this?
You can try to use Lumigent Log exploree to explore the log file and Undo that update operation

0
 
rjander77Author Commented:
Thanks to both of you.  It looks like Lumigent Log Explorer will probably do the trick, but we don't need this undone badly enough to fork over $1000, so we'll just use the backups.  Splitting the points - I appreciate the help!
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Aneesh RetnakaranDatabase AdministratorCommented:
download the trial version it wll work for 14 days and contains almost all the features.

0
 
rjander77Author Commented:
I downloaded and installed it, but it won't connect to any production databases.  It is limited to Northwind, Lumigent, etc. databases.  Thanks, though.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
hmm.. I haven't tried the Trial versions, if it is a sql server 2000 db, then u can use the trial version of red-gate log rescue
http://red-gate.com/products/SQL_Log_Rescue/index.htm
0
 
rjander77Author Commented:
I'm downloading it now and will try it later this afternoon.  I'll post back with the results.  Thank you very much for your help even after the points were distributed!
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
we are here to Help you guys, points come second.
:)
0
 
rjander77Author Commented:
I'm an idiot.  We have SQL Server 2005, so the second program didn't work either.  Thanks, though!
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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