Red Gate forums :: View topic - All UPDATE data unavilable
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

All UPDATE data unavilable

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
ellis.remotedba



Joined: 18 Feb 2008
Posts: 2
Location: Wales

PostPosted: Mon Feb 18, 2008 1:06 pm    Post subject: All UPDATE data unavilable Reply with quote

Hi Guys,

I hope you can help me, we recently had a case where the values in a table were updated incorrectly, we want to use the SQL Log Rescue tool to analyse the statement that was executed and try and determine who executed the statement. I have setup the software to point at a log shipped copy of the db and I have included the log backup for the times the updates happened. All insert and delete (new and old values) data is available but nearly all update statements show an ‘unavailable’ message listed in the new and old values… Is this a common problem or am missing something important… You help would be most appreciated.

Many Thanks

Gethyn
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 939
Location: Red Gate Software

PostPosted: Tue Aug 12, 2008 7:00 pm    Post subject: Reply with quote

Thank you for the post into the forum and sorry for the delay in replying.

If Log Rescue is unable to retrieve a value, SQL Log Rescue displays unavailable. This may occur, for example, if the selected log entry shows a row update, but there is no information about the row insertion within the live transaction log, the transaction log backups, or the included database backups.


Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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