Unicode error during database restore

[DeepDiverMom]

We backed up databases from a MS SQL Server 6.5 instance. We then attempted to restore the .BAK files on MS SQL Server 7.00.1063. At the beginning of the restore, we encountered this error:

"Microsoft SQL-DMO SQL (ODBC SQLState: 42000)
The database you are attempting to restore was backed up under a different Unicode locale (ID 33280) or Unicode comparison style (0) than the Unicode locale ID (1033) or Unicode comparison style (196609) currently running on this server. Backup or restore operation terminating abnormally. [OK]"

I have reviewed thread962-705843 "2 different Unicode Collation", which indicates that there may be a way to overcome this issue. We would like to avoid a reinstall of SQL Server with the "old" server's Unicode settings.

What, then, is the easiest/best way to resolve this issue?

Becca

 

[DeepDiverMom]

Gurus,

I'm updating this thread in an attempt to throw my problem on the mercy of "The Court" (i.e., The Forum). There have been no responses since my original posting more than two days ago. Has my problem not occurred to anyone else? Is this an issue that has no resolution, or is its resolution beyond the group's experience? If either is the case, I'll understand...I just need to know so that I can move on to some other sort of workaround.

Thanks for your patience and understanding,

Becca