Unanswered: how to move one database file from one server to another withour restoring
I am moving a database from one server to another. I am going to replace the old server to the new one. I heard that you can move the datfiles and put them in the same directory, and sql server will pickup the datafiles based on the system tables. Is this possible, and what are the steps to get this to work. Thanks for the help in advance.