I've got a database with 2 FileGroups and 3 Files. It's laid out like so: ============================================ Primary DBName_Data - EathFilename.MDF Index_Data DBName_Index - EathFilename.NDF ============================================ The Log files are: ------------------ DBName_Log.LDF EBName_Log2.LDF ============================================ We just added a new drive (raid array) to the server and I need to move the .NDF file to the new drive for performance reasons. So, my current file/paths are: EathFilename.MDF EathFilename.NDF DBName_Log.LDF EBName_Log2.LDF I need to detach the DB, and move the NDF and reattach, but I'm not sure how to do this having more than one MDF/LDF. What I want is: EathFilename.MDF GathFilename.NDF DBName_Log.LDF EBName_Log2.LDF I know to detach, all I need is: EXEC sp_detach_db 'DBName', 'true' But how do I reattach (after moving the NDF to drive G)? Thanks for any help!