Cette requête permet de faire lancer manuellement un shrink de la base pour les Logs.

USE DBName;

– Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE DBName SET RECOVERY SIMPLE;

– Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (DBName_log, 1); –File name SELECT * FROM sys.database_files; query to get the file name

– Reset the database recovery model. ALTER DATABASE DBName SET RECOVERY FULL;