SQL Server – Move database using sp_detach_db and sp_attach_db

This article will help you to understand different options for moving database files (i.e. mdf and ldf ) from one to another location and sp_detach_db and sp_attach_db statement help you to move these files. Here will give you an idea that are available with SQL Server 2005 and step by step approach for moving database ...