• The easiest way is going to be to run the RESTORE using WITH MOVE. But, that means the file layout has to be the same, even if the locations are different. Meaning, the same number of files. They can all be on different drives and have different names, but you have to have the same number.

    If you use any other method for moving the data over, SSIS, BULK INSERT, or just INSERT, you will need to run index maintenance and statistics maintenance at the end of the move process. That will ensure your indexes are defragmented and your statistics are up to date.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning