Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: restore database

    Hello,
    I'm restoring database backup from a sqlserver 7 to an other sqlserver 7 with the following command.

    USE MASTER
    RESTORE DATABASE MyBase
    FROM DISK=’D:\MYFIC.BAK’
    WITH
    MOVE ‘MyBase_Data’ TO ‘D:\MSSQL7\Data\MyBase_data.MDF',
    MOVE ‘MyBase_Log’ TO ‘D:\MSSQL7\Data\MyBae_Log.LDF’,
    REPLACE, RESTART, STANDBY=’D:\MSSQL7\BACKUP\MyBase_UNDO.DAT’,
    STATS
    GO

    The restore command failed with error messages :

    Msg 3120, Level 16, State 1, Server S20FRNDCSQLFR01, Line 1
    The database you are attempting to restore was backed up under a different sort order ID (42) than the one currently running on this server (52), and at least one of them is a non-binary sort order.
    Msg 3013, Level 16, State 1, Server S20FRNDCSQLFR01, Line 1
    Backup or restore operation terminating abnormally.



    Can you help me.It's urgent

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Read the following previous post:

    link

Posting Permissions

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