We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

• get details of the current paths\filenames using this query
  

  select name, physical_name from sys.master_files where database_id = DB_ID('yourDB')

  
  


• For each file you wish to move build a MODIFY FILE command. For the log file for instance use
  

  ALTER DATABASE [yourDB] MODIFY FILE(name=yourDB_Log,
  physical_name = 'new drive:\ new path\ new path\yourdb_data.ldf')

  
  


• issue the ALTER DATABASE statement


• take the database offline


• copy the file to the new location


• bring the database online


• delete the original file from the original location