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 urgentRead the following previous post:
link (http://dbforums.com/arch/72/2002/6/394630)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment