Post reply

Can I read the transaction log ?

  • August 18, 2004 at 12:15 pm

    #161998

    Hi,

    I would appreciate any help on this question

    Is there any way of reading the transaction log in SQL Server 7 to see what transactions where applied on a database, table, etc. ? If the answer is yes, is that a feature of MS-SQL or will I need a special software to do that ?

    (I've heard of something called Log Reader)

    Thank you in advance,

     

     

     

  • August 18, 2004 at 1:03 pm

    #519637

    SQL Server - No.

    3rd Party tool - Yes.

    Lumigent makes a log viewer tool, but it's not freeware and per my understanding, it has to be running already for you to read the log. So it's good for future needs, but if you need something to read a current log - it won't do that.

    There might be other tools, but that's the one I hear about the most. Does it work with SQL Server 7 - I don't know.

    -SQLBill

  • August 18, 2004 at 1:27 pm

    #519640

    Thanks you !

  • August 18, 2004 at 2:13 pm

    #519645

    We have installed Lumigent Log Explorer in our production server.  It works great.  You can read both online log and backup logs. 

    Gopal

  • August 18, 2004 at 2:41 pm

    #519648

    ApexSQL (http://www.apexsql.com) also has a tool which is a bit lower cost and they do lifetime upgrades.

    You could however use DBCC LOG but the data is hex in the best option and too much hassel to translate yourself.

  • August 20, 2004 at 10:48 am

    #520021

    I like Lumigent's log reader. but allow me to warn you, I believe it may interfere with standby server functionality because of its interaction with the logfile . The folks at Lumigent are great, and the product is cool, that I have seen, but the last time I messed with it, I could'nt use it because of the interference. Maybe they have changed it since.

Viewing 6 posts - 1 through 5 (of 5 total)

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