Detaching
EXEC sp_detach_db 'SMSsid', 'true'
Attaching
EXEC sp_attach_db @dbname = N'SMSsid', @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\SMSsid.mdf', @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\SMSsid_log.ldf'
Don’t forget to stop all service instances before performing a detach.