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;