use master
go
sp_detach_db @dbname='TestAttach'
sp_attach_db 'TestAttach','C:\Program Files\Microsoft SQL Server\MSSQL\Data\TestAttach_Data.MDF','D:\TestAttach_Log.LDF'
go
sp_detach_db @dbname='TestAttach'
sp_attach_db 'TestAttach','C:\Program Files\Microsoft SQL Server\MSSQL\Data\TestAttach_Data.MDF','D:\TestAttach_Log.LDF'