DATAFILES MOVE

• Couper l'applicatif
• Faire un full Backup
• lister la localisation des Datafiles

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

• Mettre la BDD Offline Changer la localisation des datafiles

use master
go
alter database SolarWindsOrionLog  set offline		
ALTER DATABASE SolarWindsOrionLog MODIFY FILE (NAME =SolarWindsOrionLog, FILENAME = 'D:\SQL_DATA\SolarWindsOrionLog.mdf')

• bouger physiquement les datafiles

• remettre la BDD ONLINE

use master
go
alter database SolarWindsOrionLog  set online