MSSQL Move Database Files

Move the MDF and LDF files to another directory.
Update DatabaseName and Directories in the below commands.

• Switch to the master database

USE master;
GO

• Put the database in offline mode

ALTER DATABASE DatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE;

• Copy files to the desired directory modify and run the below command

ALTER DATABASE DatabaseName

MODIFY FILE (NAME = data, FILENAME = 'D:\Database\DATABASE.mdf');

ALTER DATABASE {DatabaseName}

MODIFY FILE (NAME = log, FILENAME = 'D:\Data\DATABASELOG.ldf');

SELECT name, physical_name

• Verify the changes

FROM sys.master_files

WHERE database_id = DB_ID('DatabaseName');

• Bring database online

ALTER DATABASE DatabaseName SET ONLINE;