August 22, 2003 at 10:13 am
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
This is the only product that I know of. Nothing will read selects as they are not logged.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 22, 2003 at 10:31 am
Lumigent isn't the only game in town anymore. Check out Log Navigator
August 22, 2003 at 12:56 pm
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply