Red Gate forums :: View topic - Missing update statements in Transaction Log
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

Missing update statements in Transaction Log

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
hb@imagearts.de



Joined: 29 Mar 2007
Posts: 1

PostPosted: Thu Mar 29, 2007 9:49 am    Post subject: Missing update statements in Transaction Log Reply with quote

I am using Log Rescue on a database which backup-files are not recognized as backups of this database. But the backup-files are correct and I'm able to restore them into another database.
To restore the rest - from backup-time to a certain timestamp - I want to use the transaction log.
This works pretty well. All inserts, deletions and updates of inserted rows are found and corresponding statements can be created.
But Log Rescue is not able to restore some update-statements of older rows since old and new value are not available.
I understand that the old value is not available because Log Rescue has no backup to retrieve the information but the new values should be in the transaction log so Log Rescue should be able to create the update statement.

Is there any way to get these update-statements?
Back to top
View user's profile Send private message
eddie davis



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

PostPosted: Wed Apr 04, 2007 3:31 pm    Post subject: Reply with quote

Thank you for post.

Unfortunately there is nothing I can advise that will obtain these update statements for you.

If SQL Log Rescue cannot retrieve an old value or new value, (Unavailable) is displayed.

Likewise if SQL Log Rescue cannot retrieve the user information, Unrecorded (n) is displayed, where n is the user id or -1 if this is not known.

Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
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