SQL Sort Order ID error

Posted on 2005-03-14
Medium Priority
Last Modified: 2012-05-05

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.

Question by:novice12
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

lozzamoore earned 2000 total points
ID: 13537251

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,


Author Comment

ID: 13537872

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


Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question