====== Déplacer les DATAFILES ======

  * Couper l'applicatif
  * Faire un full Backup
  * lister la localisation des Datafiles
<code TSQL>			
SELECT DB_NAME() AS DbName, 
file_id, name AS logical_name, physical_name,type_desc,
size*8.0/1024/1024 AS CurrentSizeGB, 
size*8.0/1024/1024 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)*8.2/1024/1024 AS FreeSpaceGB
FROM sys.database_files
ORDER BY DbName,logical_name ASC
</code>
 
  * Mettre la BDD Offline Changer la localisation des datafiles
<code TSQL>	
use master
go
alter database SolarWindsOrionLog  set offline		
ALTER DATABASE SolarWindsOrionLog MODIFY FILE (NAME =SolarWindsOrionLog, FILENAME = 'D:\SQL_DATA\SolarWindsOrionLog.mdf')
</code>

  * bouger physiquement les datafiles

  * remettre la BDD ONLINE
<code TSQL>	
use master
go
alter database SolarWindsOrionLog  set online		
</code>