Cette requête permet de faire lancer manuellement

USE DBName;\n

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

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

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