| Author |
Message |
harryb
Joined: 10 Nov 2006
Posts: 4
|
 Posted: Fri Nov 10, 2006 9:40 am Post subject: Selecting Logs |
 |
|
I have just selcted the first 4 logs, out of many days worth.
It has kindly given me all logs.
Why? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Sat Nov 11, 2006 4:38 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
harryb
Joined: 10 Nov 2006
Posts: 4
|
| Posted: Mon Nov 13, 2006 2:09 am Post subject: Re: |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Mon Nov 13, 2006 1:45 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
myelton
Joined: 30 Jan 2007
Posts: 3
|
| Posted: Tue Jan 30, 2007 8:43 pm Post subject: |
|
|
Hi Brian,
Is the auditing functionality something that will be made more user friendly in future releases?
Mark |
|
| Back to top |
|
|
|
|
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
