novice12
asked on
SQL Sort Order ID error
I did a database full backup of Db_1 on "Server_1" to file. I then attempted to do a database restore using this file to another database Db_1 on a remote server "Server_2".
I got the follwoing error:
"The database you are attempting to restore was backed up under a differnet sort order ID (49) than the one currently running on this server(52), and at least one of them is a non-binary sort order. Backup or Restore operation treminating abnoramally"
Is there a way to fix this sort order problem?
The database Db_1 in Server_2 is still under development, so I have the freedom of experimenting with it. On the other hand, Db_1 in Server_1 is online and I can not touch.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am likely to go with the first option. I don't have SQL 2000, but I will look into buying it.
Thanks