Move SQL Server database files to a new folder location

ALTER DATABASE my SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE my SET OFFLINE;

ALTER DATABASE my MODIFY FILE
(
Name = my_Data,
Filename = ‘D:DATAmy.MDF’
);

Move the file to the new location.

ALTER DATABASE my SET ONLINE;

ALTER DATABASE my SET MULTI_USER;