Jeff Mlakar gives us three methods for migrating database files from one location to another:
The database will be unavailable during this operation so we need to notify our end users. Consider the ramifications if an application is using the database – we might want to stop application services or take some other custom action during the move.
Plan ahead before starting the job. Know what you are going to do before doing it. If you can test your method against a lab or development database that will help too.
Sound advice and technique. Click through to see those three methods.