question

I would update the location of the files for the database first, then take it offline, copythe files and bring it back online. I would copy the files rather than move them. This would allow you to revert back to the original files in the event of an issue during the copy process. Once the database is back online, you can then remove the old files. Here is some documentation that describes how to accomplish this: https://technet.microsoft.com/en-us/library/gg452698.aspx http://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files I would NOT detach/attach it. Once you detach it you are very limited to what you can do with it in the event of a problem.