Transaction log reader

Question

Post reply

Transaction log reader

SSRfromChennai

Ten Centuries

Points: 1120
More actions
July 3, 2009 at 12:53 am

#211645

Can any body refer any transaction log reader tool or about the way of reading transaction log.
July 12, 2021 at 9:02 am

This was removed by the editor as SPAM
July 12, 2021 at 9:02 am

This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SpyCraft Valued Member Points: 56 More actions · Answer 1

try APEX SQL it costs you more but good tool though..try in google u will get the link for downloading...

Dugi SSCoach Points: 17998 More actions · Answer 2

You can do it with third party tools, like RedGate Log rescue, Apex SQL, etc etc ...you can find many of them in the Internet!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

Dugi (7/3/2009)
You can do it with third party tools, like RedGate Log rescue, Apex SQL, etc etc ...you can find many of them in the Internet!

Just keep in mind that RedGate Log rescue only works for SQL 2000 not 2005 or higher.

[font="Verdana"]Markus Bohse[/font]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

What is it that you want to find from the transaction log?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dugi SSCoach Points: 17998 More actions · Answer 5

MarkusB (7/3/2009)
Dugi (7/3/2009)
You can do it with third party tools, like RedGate Log rescue, Apex SQL, etc etc ...you can find many of them in the Internet!
Just keep in mind that RedGate Log rescue only works for SQL 2000 not 2005 or higher.

Thanks for the Info :-P...we are discussing in SQL Server 2005 forum, it must worked!

:w00t:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

SSRfromChennai Ten Centuries Points: 1120 More actions · Answer 6

[font="Tahoma"]Thanks everyone.

I would like to know what data is available in TLog .

Scenario, I have set the Recovery model in bulk-logged . I have taken the transaction log backup and prior to that we have full, differential.

In the middle of the transaction log backup schedule , the Bulk-logged activites done. Prior to the bulk logged activites , some dml activites were done. At some point, some delete command was issued without setting any criteria and the data lost .

But it was realised after some time. It was not sure what time the command was issued but the data was lost. To recover the data, if the transaction log back up contains the bulk logged activites, the restore would fail. If we are able to read the transaction log, then we can recover the data from the transaction log backup by issueing 'startup' command with recovery option.

I am looking if there is any SQL commands or methods by microsoft other than third party tools.

[/font]