Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

SQL Sort Order ID error

I did a database full backup of Db_1 on "Server_1" to file. I then attempted to do a database restore using this file to another database Db_1 on a remote server "Server_2".

I got the follwoing error:
"The database you are attempting to restore was backed up under a differnet sort order ID (49) 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 treminating abnoramally"

Is there a way to fix this sort order problem?

The database Db_1 in Server_2 is still under development, so I have the freedom of experimenting with it. On the other hand,  Db_1 in Server_1 is online and I can not touch.

1 Solution

This is an unfortunate limitation of SQL 6.5 and SQL 7 environment where a server has a fixed sort order, and you can't restore a DB of a different sort order to it.


1) Build/Rebuild Server_2 a SQL 2000 server, and restore Db_1 to this, as you can restore a database with any Sort order in SQL 2000 (now called collations)

2) Keep Server_2 as SQL7 but rebuild it as Sort Order 49. This can be done using the rebuildm utility.
(Do a search on SQL7 BOL for sp_helpsort and rebuildm to help you.)

Hope this helps,

novice12Author Commented:

I am likely to go with the first option. I don't have SQL 2000, but I will look into buying it.


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now