restore database failed on SQL7

Hello,
I have 2 servers NT4SP6a_US with MSSQL7SP4_US. I backup the database with
the SQL7 MMC on the server A.
On the server B, when I try to restore the database I get the following
error :
"The database you are attempting to restore was backuped up under a
different sort order ID (51) than the one currently running on this serveur
(52), and at least one of them is a non-binary sort order. Backup or restore
operation terminating abnormally."
Can anyone tell me how to resolve this issue of sort order ?
Regards.In SQL Server 7 there is no way to do this other than
1. Rebuild the servers so sort orders match. This has inherent problems
in that all your other User DBs are worthless.
2. DTS
3. Script and BCP
Have a look here
http://tinyurl.com/yry2
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"bd207-1-adsl" <bd207-1@.dial.oleane.com> wrote in message
news:eWyHDDAwDHA.1744@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have 2 servers NT4SP6a_US with MSSQL7SP4_US. I backup the database with
> the SQL7 MMC on the server A.
> On the server B, when I try to restore the database I get the following
> error :
> "The database you are attempting to restore was backuped up under a
> different sort order ID (51) than the one currently running on this
serveur
> (52), and at least one of them is a non-binary sort order. Backup or
restore
> operation terminating abnormally."
> Can anyone tell me how to resolve this issue of sort order ?
> Regards.
>