Een klein script wat alle databases op een SQL Server aanpast naar een simple recoverymodel, en daarna de logbestanden shrinkt.
/**********************************************/
/******Script to generate Query to shrink Log file******/
/**********************************************/
set nocount on
SELECT
'ALTER DATABASE [' + d.name + N'] SET RECOVERY SIMPLE' +CHAR(13) + CHAR(10)
+ 'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
+ 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)'
+ CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM
sys.master_files mf
JOIN sys.databases d
ON mf.database_id = d.database_id
WHERE d.database_id > 4 and mf.type_desc = 'LOG'
/**********************************************/
Gebaseerd op https://saurabhsinhainblogs.blogspot.com/2014/04/how-to-shrink-all-database-log-files.html