Shrink multiple databases at a time
DECLARE @logName as nvarchar ( 50 ) DECLARE @databaseID as int DECLARE db_cursor CURSOR FOR SELECT TOP 10 name , database_id -- only 10 but you can choose any number FROM sys . master_Files WHERE physical_name like '%.ldf' and physical_name not like 'C:\%' -- specify your database paths and name not in ( 'mastlog' ) -- any database logs that you would like to exclude ORDER BY size DESC OPEN db_cursor FETCH NEXT FROM db_cursor INTO @logName , @databaseID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @databaseName as nvarchar ( 50 ) SET @databaseName = DB_NAME ( @databaseID ) DECLARE @tsql nvarchar ( 300 ) SET @tsql = 'USE [' + @databaseName + '] ALTER DATABASE [' + @databaseName + '] set recovery simple DBCC SHRINKFILE (' + @logName + ' , 1)' EXEC ( @tsql ) FETCH NEXT FROM db_cursor INTO @logName , @databaseID END CLOSE db_cu...