(Unavailable) value for some columns

Undo for SQL Server.

Moderator: eddie davis

(Unavailable) value for some columns

Postby csco1550 » Fri Oct 21, 2005 12:31 am

it shows (Unavailable) for the old value and new value for some columns under "row data" tab and "row history" tab
csco1550
 
Posts: 6
Joined: Thu Oct 20, 2005 11:30 pm

Postby Brian Donahue » Fri Oct 21, 2005 10:16 am

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby csco1550 » Fri Oct 21, 2005 6:19 pm

they are not BLOB, they are
CustomerName varchar(200) NOT NULL
ProgramType varchar(50) NULL
csco1550
 
Posts: 6
Joined: Thu Oct 20, 2005 11:30 pm

I am so disappointed

Postby csco1550 » Mon Oct 31, 2005 8:42 pm

:( 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...
csco1550
 
Posts: 6
Joined: Thu Oct 20, 2005 11:30 pm

Postby Brian Donahue » Tue Nov 01, 2005 3:21 pm

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests