摘自BOL,供你参考:
the sort order and character set of two servers must match to backup on one server and restore on the other. An exception is when both servers use a binary sort order; then, the character sets can differ. When the code page or sort order differs, use the bcp utility or Data Transformation Services to move the data