When applying a transaction log to a DB, I get the following error:
Invalid transaction log (id=3, page_no=0x00000048, offset=0x0f75): identity value not found
What does 'identity value not found' mean ?
Using SA 22.214.171.1248
asked 03 May '16, 09:58
The word "identity" in that error is referring to identity of the row being changed at that point in the transaction log. This identity would usually consist of the primary key values (if a pkey exists or some stand in) and it is just at that point where the corruption in the transaction log was detected.
So basically this is happending at a point where there is some kind of an update or delete operation ... but the main message is the log file is corrupted. And that is really all we now about this. Prior to Engineering change# 756886 you would not have even seen this extra text ... just the error text up to the closing ')'.