Red Gate forums :: View topic - (Unavailable) value for some columns
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

(Unavailable) value for some columns

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Fri Oct 21, 2005 12:31 am    Post subject: (Unavailable) value for some columns Reply with quote

it shows (Unavailable) for the old value and new value for some columns under "row data" tab and "row history" tab
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Fri Oct 21, 2005 10:16 am    Post subject: Reply with quote

Hello,

This can happen in the case of some BLOB columns. Binary Large Objects get scattered around the transaction log and sometimes can't be recovered for that reason. If this is not a text/ntext/image column please let me know.
Back to top
View user's profile Send private message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Fri Oct 21, 2005 6:19 pm    Post subject: Reply with quote

they are not BLOB, they are
CustomerName varchar(200) NOT NULL
ProgramType varchar(50) NULL
Back to top
View user's profile Send private message
csco1550



Joined: 20 Oct 2005
Posts: 6

PostPosted: Mon Oct 31, 2005 8:42 pm    Post subject: I am so disappointed Reply with quote

Sad I am so disappointed that no one answer my questions, the trial version is expiring, Does anyonehere know similar product which I can try? I heard logviewer or something...
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Tue Nov 01, 2005 3:21 pm    Post subject: Reply with quote

Hello there,

The data from the log could be unavailable because the data has been overwritten in the log. This could happen on databases that use the Full recovery model when a full backup is done. It could also be that the database is using the simple recovery model. In the latter case, there is no guarantee that the data will be available.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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