Solved

How can I rollback transactions from the log file

Posted on 2006-10-23
5
223 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
  • 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 42

Expert Comment

by:EugeneZ
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 42

Assisted Solution

by:EugeneZ
EugeneZ 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Designer 19 42
sql server insert 12 30
Sql server function help 15 31
Help creating a spatial object in SQL Server 4 23
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

810 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