
In that article I outlined a "trick" you can use if the new server will have the same logical drive configuration as the old one. If the logical drive configuration is different or you only want to move a portion of your files, usually the easiest way is to detach them from the original server and then attach to the new one, which gives you the chance to change the physical locations of the files for each database. The downside to that is that if you have a lot of databases to move, it gets very tedious indeed!
|