Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    2

    Unanswered: restore mssql 7.0. database

    When I try to restore mssql 7.0 database,I got strange error :

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

    Is there a way how i can fix it ?
    Thanks a lot !

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You need to change sort order by using REBUILDM utility to rebuild the master database, refer to books online for more information.

    Or rebuild the target server with source server's collation settings.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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