Detach and Attach SQL Server Database
how to Detach and Attach SQL Server Database using SQL Server Management studio?
According to the above, picture Detach your Selected database.
Move Database File Old Location to New location,
Ex: C:\databaseusergroup.mdf to D:\databaseusergroup.mdf
And Next Select "Attach" like Following Picture,
Attach Database like Following Pictures,
(If You Have multiple data file then you need to select only main MDF file)
and Most welcome your comments and ideas...