Sure this is to do with the sort order of the database. You can check by
running "sp_helpsort" in SQL on both databases.

In SQL Server 7 and earlier, the only way I knew round this was to copy the
database out in flat file format or similar (bcp?) - SQL Server 2000 is a
lot better with the introduction of "Collation Name" in the properties of
the database. Sorry, not making much sense here, but my experience was that
you could not restore a database of a different sort order into SQL Server
6.5 and 7.0, though you can in 2000 using "Collation Name".

Hope this helps.

Kevin Mc

Kevin McLachlan
Senior Technical Consultant
Tel: 0116 253 6010
mailto:[Email Address Removed] Message-----
From: Shawn Smith [mailto:[Email Address Removed] 16 May 2002 14:32
To: '[Email Address Removed] Can not restore from backup


Trying to restore test database from prod backup and get the following
error:

The database you are trying to restore was backed up under a different
Unicode locale ID (33280) or Unicode comparison style (0) than the Unicode
locale ID (33280) or Unicode locale ID (33280) or Unicode comparison style
(196609) currently running on this server.

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page