[SQL Server] method of transferring the location of the database MDF or LDF file, and restarting the issue with no permissions

0. View the database file name and physical file name

SELECT  as current_file_location  from Sys.master_files

1. Run the command

 UseMaster--Run from MasterALTER DATABASEdbmodifyFILE(Name='DB', filename='C:\NewPath\Database.mdf');ALTER DATABASEdbmodifyFILE(Name='db_LOG', filename='C:\NewPath\Database_log.ldf');ALTER DATABASEDbSETOFFLINE with ROLLBACKIMMEDIATE;

2. Move files, check permissions

* Move database files (including mdf/ldf) C:\NewPath

* Explorer: C:\NewPath, Properties----security--Add location: Select this machine, do not select domain-type ' NT service\mssqlserver ' search, select ' Mssqlserv ER ', allow Full Control

3. On-line

ALTER DATABASE SET ONLINE;

[SQL Server] method of transferring the location of the database MDF or LDF file, and restarting the issue with no permissions