I'm restoring database backup from a sqlserver 7 to an other sqlserver 7 with the following command.
RESTORE DATABASE MyBase
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’,
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.