Couldn't locate object with name 'sysclsobjs' in schema ID4

[studentstf]

I'm testing SQL Compare 10.1. I have two backups of a database about 17 GB each other, one was made on sql server 2005 before migration to sql server 2008 r2, and another after. When I try to compare these backups, Sql Compare 10.1 trial version stop working with error "Couldn't locate object with name 'sysclsobjs' in schema '' (ID 4)".

[Brian Donahue]

I can understand why you would get this error, since sysclsobjs is a system object and therefore should be in the "SYS" schema. I don't know how the database got into this state, though. It looks as if possibly someone made manual changes to the system catalog, but SQL Server is designed to prevent you from doing that.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

Ah, scratch that - it looks like an error in creating a view in the temporary database created to hold information about objects in the backup. SQL Compare's backup reader creates a temporary table on the hard disk and uses that to store a mock-up of the sys schema.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

Hello,

Is this situation still occurring, or was it a one-off?
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

I suppose you could delete all temoirary files (using the Windows Disk Cleanup Utility) and try again... if that doesn't work, try restoring the backup file to SQL Server... it may be corrupt.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521