Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    4

    Question Unanswered: Restore databases under SQL 6.5

    Hello,

    I'm running SQL 6.5 on an old NT4 server. I built a new W2K server with SQL 6.5.

    When I tried to restore a database to the new server I got the following error: "The database you are attempting to LOAD was DUMPed under a different sort order ID (52) than the one currently running on this server (32), and at least one of them is a non-binary sort order."
    Since SQL 6.5 is no longer supported by Microsoft, I have a hard time finding information related to that error. Can someone help me and tell me what's wrong?

    Regards,
    Toan.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The default sort order for MS-SQL 6.5 was 52. My guess is that you specified a different sort order, and that you can't restore the database unless you reinstall SQL 6.5 with the default sort order.

    -PatP

  3. #3
    Join Date
    May 2004
    Posts
    4
    Pat,

    Thanks for your help. I installed SQL 6.5 with the default settings. Where do you specify the sort order?

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It has been a LONG time since I've installed MS-SQL 6.5, but the sort order is specified somewhere very early in the installation process.

    Have you considered using SQL 7.0 instead, and restoring the dump into a database there? It seems to me that you can restore a 6.5 dump onto a 7.0 server, and that they aren't nearly as finicky about sort orders.

    -PatP

  5. #5
    Join Date
    May 2004
    Posts
    4

    Thumbs up

    You were right, the sort order ID has to be selected during the installation. Now I have to figure out which sort order was used on the old box.

    Thanks Pat for your help.

    Toan.
    Last edited by maifriend; 05-18-04 at 19:07.

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    52 is the default value, if that helps any.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •