Unhandled BLOB type for 167

Undo for SQL Server.

Moderator: eddie davis

Unhandled BLOB type for 167

Postby balford » Tue Jun 10, 2008 11:44 pm

After processing the full backup file (.bak) and 10 transaction log (.trn) files and reaching 28% on post processing, this error comes up. I should never have bragged about how helpful Log Rescue was going to be.

Has anyone else seen this error and resolved the issue?

Thanks,
Bob Alford
balford
 
Posts: 1
Joined: Wed May 14, 2008 7:53 pm
Location: Seattle, WA USA

Postby meb97me » Tue Nov 04, 2008 12:15 pm

hi

not resolved this i'm afraid but i've just come across the same issue myself

so any help also appreciated
meb97me
 
Posts: 1
Joined: Tue Nov 04, 2008 12:04 pm

Postby Robert » Tue Nov 04, 2008 2:56 pm

Hi,

I've just had a quick look in the code, and it appears to be a varchar entry that for some reason is ending up in an area that SQL Log Rescue thinks should be a BLOB (remembering that SQL2000 didn't support varchar(max)).

The only thing I can think of here is if a column changed data type some time in the past, from a text column to varchar?

It might be worth trying again with only the more recent transaction log backups - if the error occurs in an earlier backup, that could allow you to recover at least the latest transactions.

Sorry I can't be of more help!

Robert
Robert Chipperfield
Developer, Red Gate Software Ltd
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests