Different Sort Order ID

[cocopud]

I backed up our database with SQL 7 Backup. I then moved the file and tried to restore it onto or test server (also have SQL 7), but I received the following error:

The database you are attempting to restore was backed up under a different sort order ID (32) than the one currently running on this server (52), and at least one of them is a non-binary sort order.
Backup or restore operation terminating abnormally.

Is there an easy was to change this sort order so that I can get the backup and restore to a different machine to work?

 

[SQLBill]

I have your answer, but you aren't going to like it.

This deals with COLLATION settings.

32 = SQL_Latin1_General_Cp437_CI_AS
52 = SQL_Latin1_General_Cp1_CI_AS

According to the BOL, you must rebuild the Master and user databases to change the collation.

Refer to BOL, use Index tab, enter Collations, changing settings. Then chose the option for "Changing collation options after installing..."

-SQLBill

 

[SQLBill]

After posting the above.....I found another possiblity, which you MIGHT like.

Run the ALTER DATABASE command...

ALTER DATABASE mydb_name COLLATE SQL_Latin1_General_Cp437_CI_AS

But this will NOT change the SERVER collation. There are also lots of warnings about this....(about what it does and doesn't do)

******BEFORE YOU RUN THE ABOVE************
Refer to the BOL, use the Index tab and enter collation, changing

-SQLBill

 

[cocopud]

Thanks, I will look into these two options