This topic describes how to move a detached database to another location and re-attach it to the same or a different server instance in SQL Server 2012. However, we recommend that you move databases by using the ALTER DATABASE planned relocation procedure, instead of using detach and attach. For more information, see Move User Databases.

Continue reading