Solved

How can I rollback transactions from the log file

Posted on 2006-10-23
5
227 Views
Last Modified: 2008-03-17
Hello, I have a SQl 7.0 database that has been corrupted.  Our backup was rewritten with the corrupted data so any time I restore the DB, I get the same error.

My question is: can we use the log file to restore the database to a few days earlier so the corrupted data is erased from the system?

Thank you,

LR
0
Comment
Question by:Luis_Romero
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 29

Accepted Solution

by:
Nightman earned 250 total points
ID: 17791293
Give ApexSQL a try (http://www.apexsql.com/sql_tools_log.asp). Not free, but has a 14day trial period.
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 17791792
just if you have not corrupted database backup

BTW: what in your case "corrupted"?
did you mean - somebody deleted or changed data?
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 250 total points
ID: 17791827
correction:
just if you have not corrupted database backup you can restore database to point of failure ( if it had transactional log backup)

How to restore from a transaction log:
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1158531_tax301326,00.html?adg=301324&bucket=ETA

also there are:
Red-gate
SQL Log Rescue
http://www.red-gate.com/products/sql_log_rescue/index.htm

 Log Explorer for SQL Server
http://www.lumigent.com/products/le_sql.html 

0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

627 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