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.