Red Gate forums :: View topic - Appears to be a bug to me...
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

Appears to be a bug to me...

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
twilkinson@uh.org



Joined: 13 Jul 2006
Posts: 6

PostPosted: Thu Jul 13, 2006 7:42 pm    Post subject: Appears to be a bug to me... Reply with quote

I downloaded the trial and was trying to view contents of transactions within a log file backup. This is what I have notice...

I pick yesterday log file on a server that does not truncate the logs... it works.

I pick yesterday log file on a server where I truncate the logs at night... it does not work.

My goal is to view a transaction that occurred during a 2 hour window on my server that happens to be one that truncates the log after reindexing.

Now I'm sure to someone that makes sense but it does not to me since all I'm concerned with is this 2 hour window from the previous day.

The message I get is... "this file has been ignored because it contains no relevant backup information."

I only get the message when I choose a log file that is prior to the log being truncated from what I can tell.

Is it possible for the application just to show me the entries in a single transaction log file as well? During my testing on a different server I chose a file from the previous day. That file has 15 minutes of transaction log backup data within it (this is a server btw where the log is not truncated after indexing). Not only did I get the 15 minutes of transactions I wanted but I got the active log too. What a pain... all this additional processing took place for something I didn't care to see.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Fri Jul 14, 2006 5:37 pm    Post subject: Reply with quote

Hello,

Normally, the error message indicates that there is a gap in the transaction history. Log Rescue needs the full backup, and then a consistent chain of log backups leading back to the full backup. If there is a gap in the history, the backup files will be ignored. I think that may be the problem here.
Back to top
View user's profile Send private message
twilkinson@uh.org



Joined: 13 Jul 2006
Posts: 6

PostPosted: Fri Jul 14, 2006 5:50 pm    Post subject: Reply with quote

My normal backups are litespeed backups and the current day translogs work while previous day does not... that is... on the box where I truncate the log after indexing. So I'm not understanding where the full backup comes into play here. Also if there is a gap is transaction history... so what, display a warning about the gap and then display the transaction available. In my case that would be perfect because the issue I have is that we were looking for a single delete transaction between 2pm and 4pm which I could not retrieve.

Is there a way that a single file transactions can be displayed instead of the "file select" + live log?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6678

PostPosted: Mon Jul 17, 2006 7:03 pm    Post subject: Reply with quote

Hello,

I don't know the specifics in great detail, but since Log Rescue is primarily designed to recover data, it needs to have an initial state of the table schema and data to work with. If it doesn't, it can't reconstruct an entire table drop, which is one of the design goals.
Back to top
View user's profile Send private message
twilkinson@uh.org



Joined: 13 Jul 2006
Posts: 6

PostPosted: Mon Jul 17, 2006 7:20 pm    Post subject: Re: Reply with quote

Maybe I'm looking for the wrong product... If I follow you correctly your product will allow me to restore an drop table which I can see to be useful. My case I'm wanting to see the data within a single transaction log backup. I tend to get about 3-5 calls a month where we need to find records that were changed or deleted by mistake, so in my case I don't need to see all of the logs... just one or two files.

Brian Donahue wrote:
Hello,

I don't know the specifics in great detail, but since Log Rescue is primarily designed to recover data, it needs to have an initial state of the table schema and data to work with. If it doesn't, it can't reconstruct an entire table drop, which is one of the design goals.
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