(Unavailable) value for some columns

csco1550csco1550 Posts: 8
edited November 1, 2005 9:21AM in SQL Log Rescue
it shows (Unavailable) for the old value and new value for some columns under "row data" tab and "row history" tab
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • csco1550csco1550 Posts: 8
    they are not BLOB, they are
    CustomerName varchar(200) NOT NULL
    ProgramType varchar(50) NULL
    · Share on Twitter
  • csco1550csco1550 Posts: 8
    :( 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...
    · Share on Twitter
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
This discussion has been closed.