>What I'm mainly concerned with here is moving SQL files between 2 machines which are not necessarily linked with one another...I received the following reply from Yair Alan Griver on this question:
>
>"Basically, you can detach and reattach, or create a backup and restore on
>the other machine. Until SQL7, you couldn't do the first, so I tend to stick
>to the second out of habit..."
When using backup/restore to move databases, the only thing to watch out for is that both servers must have the same character set and sort order.
-Mike