What is the easiest/fastest way to move all of the database files over to the new drives? I want to leave the log files alone.

BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into Microsoft SQL Server using mv.SSIS in a free webinar on Tuesday, January 31.

What is the best way to do this? File locations will be different on new server.Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with new ...