After trying to restart moved database: Unable to open the physical file "D:\Data\MYDBNAME.MDF"
While the database is offline, you need to copy the files to the new location. This is not something that SQL Server does automatically when you alter the file location. My preferred method is to use the following steps:


Set the database offline
Copy (don't move) the database files
After copy completes successfully, ALTER DATABASE...MODIFY FILE to change metadata for file locations
Set the database online
Confirm the database restarts successfully


If there's a problem bringin the database online, the files are still in the original location, so you can rollback.

Delete the old files


When performing the copy, you'll need to ensure that the permissions on the files are the same in the new location as in the old location. Otherwise, you'll run into different problems.

If you are using ROBOCOPY to move the files, you can use the /COPYALL flag to ensure that security &amp; file info is copied along with the file.

You can also manually verify the permissions, and verify that the folder permissions are inherited to all contents of the directory.