Restore to New Server

[STibbs]

This is the command I am running

Restore Database {DatabaseName}
from UlysData with replace

This is the message I get.

Server: Msg 3120, Level 16, State 1, Line 1
The database you are attempting to restore was backed up under a different sort order ID (54) than the one currently running on this server (52), and at least one of them is a non-binary sort order.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.

I am trying to tranfer the data base from one server to another. I was told not to us the DTS package as it was flawed. Can not find anything in Technet or books on-line to sort this out. Any ideas of step that I may have missed?

 

[STibbs]

For get what I wrote. I discover that the SQL server that I was tranferring the data to did not have the Same sort order when it was installed. I ran the program rebuildm.exe on the server and recreated the master files. Now I am back in business. Thanks to a previous posting on this forum I was able to sort it out. Thanks everyone.