Detach and attach via CMD

gistfile1.sql

USE MASTER;
GO
-- Take database in single user mode -- if you are facing errors
-- This may terminate your active transactions for database
ALTER DATABASE Piloto
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
-- Detach DB
EXEC MASTER.dbo.sp_detach_db @dbname = N'Piloto'
GO

-- Move MDF File from Loc1 to Loc 2
-- Re-Attached DB
CREATE DATABASE [Piloto] ON
( FILENAME = N'H:\Data\Piloto.mdf' ),
( FILENAME = N'G:\Log\Piloto.ldf' )
FOR ATTACH
GO


ALTER DATABASE Piloto
    SET READ_COMMITTED_SNAPSHOT ON;