• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

How can I rollback transactions from the log file

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
Luis_Romero
Asked:
Luis_Romero
  • 2
2 Solutions
 
NightmanCTOCommented:
Give ApexSQL a try (http://www.apexsql.com/sql_tools_log.asp). Not free, but has a 14day trial period.
0
 
Eugene ZCommented:
just if you have not corrupted database backup

BTW: what in your case "corrupted"?
did you mean - somebody deleted or changed data?
0
 
Eugene ZCommented:
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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