Post reply

read backup transaction log

  • August 22, 2003 at 10:13 am

    #59093

    Hi,

    Management wants to confirm some transactions happened a few days ago in a reporting format. I know Log Explorer can read backup transaction logs, but only insert, delete, update, not select. Is there any other products available that can read transaction log backups? or this is the only production you know that can do this?

    Any info is greatly appreciated. Thanks!

    -- Wei

  • August 22, 2003 at 10:15 am

    #471017

    This is the only product that I know of. Nothing will read selects as they are not logged.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • August 22, 2003 at 10:31 am

    #471029

    Lumigent isn't the only game in town anymore. Check out Log Navigator

    http://www.lockwoodtech.com

  • August 22, 2003 at 12:56 pm

    #471053

    Thanks very much Steve and gfahrlander.

    gfahrlander, have you tried log navigator? I downloaded it and tried it. I know bunch of records were deleted from one table during a certain period of time. (I have hourly transaction log backup.) When I tried to do a log analyze from the transaction log backup file, I can only see bunch of updates in the user table, not those deletion I am looking for. not sure if it still can't read detached log? or I didn't do it correctly.

Viewing 4 posts - 1 through 4 (of 4 total)

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