Example: Moving database files using Offline and Online method
--Create new database sales
Create database sales
--Check current path
sp_helpdb sales
--Create folder and grant read/write permissions to service account
--ex. d:\Data\SalesFiles
--step3: Modify the file path
use master
go
alter database Sales modify file
(name='Sales',filename='D:\DATA\SalesFiles\Sales.mdf')
go
alter database Sales modify file
(name='Sales_log',filename='D:\DATA\SalesFiles\Sales_log.ldf')
go
--step4: Take database offline
use master
go

alter database Sales set offline with rollback immediate
--step5: Move the files into new folder(s)
--step6: Bring online
alter database Sales set online
--step7: Check new path

sp_helpdb sales