Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002

    Question Unanswered: SQLServer restore error due to unicode

    I am trying to restore a SQL 7 database from one machine to another however I receive the a message similar to the following error message :-

    The database you are attempting to restore was backed up under a different Unicode locale ID or Unicode comparison style

    I have attached a screen shots

    Anyone know how I can work around this ???

  2. #2
    Join Date
    Feb 2002
    The db data in the backup is sorted in a different way than the new db is.

    Run sp_helpsort on both machines to see what differs. They must look the same. Use the exe rebuild_m to change sortorder in the new db to match the other.

    / Jonas
    - Jonte

Posting Permissions

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