All UPDATE data unavilable

Undo for SQL Server.

Moderator: eddie davis

All UPDATE data unavilable

Postby ellis.remotedba » Mon Feb 18, 2008 1:06 pm

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
ellis.remotedba
 
Posts: 2
Joined: Mon Feb 18, 2008 1:00 pm
Location: Wales

Postby eddie davis » Tue Aug 12, 2008 7:00 pm

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
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests