database files movement from one drive to another drive in sql server

1) Capture the .mdf and ldf file names of that particular datbase to which you want to move 
   SELECT * FROM  sys.master_files
2) Ensure that you have latest .BAK file available for rollback plan
3) Take that particular database alone into OFFLINE
   ALTER DATABASE database_name
   SET OFFLINE
4) Move the files to new location
5) Run the below command make changes at system catlogue level

USE master
GO
ALTER DATABASE AdventureWorks2012   
MODIFY FILE( NAME = AdventureWorks2012_Log,   
            FILENAME = 'C:\NewLoc\AdventureWorks2012_Log.ldf');  
GO
ALTER DATABASE AdventureWorks2012   
MODIFY FILE ( NAME = AdventureWorks2012_Data,   
                  FILENAME = 'C:\NewLoc\AdventureWorks2012_data.mdf'); 
6) Bring the database ONLINE
ALTER DATABASE database_name
SET ONLINE
7)Once the database came online run the below commmand to chek whether the new path appearing at catlogue level

SELECT name, physical_name AS CurrentLocation, state_desc  
FROM sys.master_files  
WHERE database_id = DB_ID(N'<database_name>'); 

Databases files movement with Powershell code.

$sererName = "servername"
$dbs = @("dbname")
$newPath = "D:\MSSQL\DATA"

$files = Get-DbaDbFile -SqlInstance $sererName -Database $dbs -Verbose |
    Select-Object LogicalName, Type,
        @{Name='PhysicalFile'; E={ $_.PhysicalName | Split-Path -Leaf }},
        Database |
    Sort-Object -Property Type

foreach ($file in $files) {

    if ($file.Type -eq 0) {

        Write-Host 'I am moving data file here' -ForegroundColor DarkRed -BackgroundColor Yellow

        Write-Output @"
ALTER DATABASE [$($file.Database)]
MODIFY FILE (NAME = [$($file.LogicalName)], FILENAME = '$newPath\$($file.PhysicalFile)');
"@
    }

    if ($file.Type -eq 1) {

        Write-Output ""

        Write-Host 'I am moving logfile (.ldf) file here' -ForegroundColor DarkYellow -BackgroundColor DarkRed

        Write-Output @"
ALTER DATABASE [$($file.Database)]
MODIFY FILE (NAME = [$($file.LogicalName)], FILENAME = '$newPath\$($file.PhysicalFile)');
"@
    }
}