transaction log viewer

[jcaulder]

Anyone know where to find a free/evaluation version transaction log viewer that can be downloaded from the web?

I've seen one somewhere in my browsing around but can't remember where it was.

Thx

J

 

[JayKusch]

Lumigent Log Explorer has a demo. Great tool! Has saved me alot of work in recovering data and such!

Thanks

J. Kusch

 

[jcaulder]

Thanks for the reply!

Unfortunately, the demo only lets you view northwind and pubs transaction logs. Because of the size of my database, I'm not sure I can restore northwind from my live backup to get the viewer to show me what I really want to see.

Thanks!

 

[ClaireHCM]

check points --- dbcc shrinkdatabase --- dbcc shrinkfile
then try to use Tran log viwer again.
Note,When people are accessing the database,you cant shrink it.

 

[SonOfEmidec1100]

Have you tried DBCC LOG ('mydbname', n) It returns the contents of the transaction log. Values of n can be 0-4 gives different results. But avoid 3 causes low resource message. Doesnt seem too much doco on this Q119402 mentions it.

So how you interpret the results is another story I cant help there..