Red Gate forums :: View topic - Selecting Logs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

Selecting Logs

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
harryb



Joined: 10 Nov 2006
Posts: 4

PostPosted: Fri Nov 10, 2006 9:40 am    Post subject: Selecting Logs Reply with quote

I have just selcted the first 4 logs, out of many days worth.

It has kindly given me all logs.

Why?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Sat Nov 11, 2006 4:38 pm    Post subject: Reply with quote

Hello Harry.

If I'm not mistaken, the question is 'why is Log Rescue showing me more transactions than exist in my transaction log backup files?'. I believe the answer to this is that Log Rescue reads the live database log (ldf file) in addition to the log backups that you have specified. Log Rescue uses a combination of the information in the log backups as well as the information in the log.

If I'm wrong, please let me know.
Back to top
View user's profile Send private message
harryb



Joined: 10 Nov 2006
Posts: 4

PostPosted: Mon Nov 13, 2006 2:09 am    Post subject: Re: Reply with quote

You are correct, but I want to see what happened during the logs I have chosen, not the active log.

The only solution I can see is to backup the current log, so making it smaller and try again.

Ok, I am not using the product to recover data, I am trying to find who and when certain data was updated, do I have to purchase Lumingent? I assumed this would have been possible with log rescue.

Harry

Brian Donahue wrote:
Hello Harry.

If I'm not mistaken, the question is 'why is Log Rescue showing me more transactions than exist in my transaction log backup files?'. I believe the answer to this is that Log Rescue reads the live database log (ldf file) in addition to the log backups that you have specified. Log Rescue uses a combination of the information in the log backups as well as the information in the log.

If I'm wrong, please let me know.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6647

PostPosted: Mon Nov 13, 2006 1:45 pm    Post subject: Reply with quote

Hi Harry,

Log Rescue can be aused for auditing in a pinch -- but it's not really designed for that. It's designed to recover data lost as the result of a transaction that went wrong.

You can still filter the results in Log Rescue to show transactions only between a certain time period, but the fact remains that the software needs to analyze the log before it can do anything.
Back to top
View user's profile Send private message
myelton



Joined: 30 Jan 2007
Posts: 3

PostPosted: Tue Jan 30, 2007 8:43 pm    Post subject: Reply with quote

Hi Brian,

Is the auditing functionality something that will be made more user friendly in future releases?

Mark
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group