Need to reduce K2 log file

Hi All,

You can check with your DBA for confirmation if needed.
You can follow manual shrink advice by these sites but it will need lot of manual steps:
Change SQL from Full Recover to Simple Recovery Model | GoEngineer
https://www.goengineer.com/blog/change-sql-from-full-recover-to-simple-recovery-model
Truncate and shrink log files in SQL Server (rackspace.com)
https://docs.rackspace.com/docs/truncate-and-shrink-log-files-in-sql-server
Shrink Logs for a Database in Single Recovery mode - Microsoft Q&A
https://learn.microsoft.com/en-us/answers/questions/1181664/shrink-logs-for-a-database-in-single-recovery-mode

To be quicker, you can execute this script to get advice statement to do the change from recovery mode simple if needed, and change it again to full after SHRINKDATABASE command, 
This script will provide advice statement for your current DB (please connect on K2 DB):


DECLARE @dbname VARCHAR(100)
DECLARE @dbRecoveryType VARCHAR(100)
DECLARE @dbid INT

DECLARE curDatabases CURSOR FOR
SELECT name, database_id,databases.recovery_model_desc
FROM sys.databases
WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')
AND Name = DB_NAME() --You can remove this to shrink all your database of your SQL server instance.

OPEN curDatabases
FETCH NEXT FROM curDatabases INTO @dbname, @dbid,@dbRecoveryType
WHILE @@FETCH_STATUS = 0 BEGIN
BEGIN
DECLARE @dbfilename VARCHAR(100)
PRINT 'PRINT '''''
PRINT 'PRINT '''''
PRINT 'PRINT ''DB ' + @dbname + ''''
PRINT 'USE MASTER'
PRINT 'GO'

IF (@dbRecoveryType!='SIMPLE') BEGIN
PRINT 'ALTER DATABASE [' + @dbname + '] SET RECOVERY SIMPLE WITH NO_WAIT'
PRINT 'GO'
END

PRINT 'USE [' + @dbname + ']'
PRINT 'GO'

DECLARE curFiles CURSOR FOR
SELECT name
FROM sys.master_files
WHERE type = 1
AND database_id = @dbid

OPEN curFiles
FETCH NEXT FROM curFiles INTO @dbfilename
WHILE @@FETCH_STATUS = 0 BEGIN

PRINT 'DBCC SHRINKFILE ([' + @dbfilename + '], 1)'
PRINT 'GO'

FETCH NEXT FROM curFiles INTO @dbfilename
END
CLOSE curFiles
DEALLOCATE curFiles

PRINT 'PRINT ''SHRINKDATABASE '''
--DBCC SHRINKDATABASE (N'K2')
PRINT 'DBCC SHRINKDATABASE (N''' + @dbname + ''')'

IF (@dbRecoveryType!='SIMPLE') BEGIN
PRINT 'ALTER DATABASE [' + @dbname + '] SET RECOVERY ' + @dbRecoveryType
PRINT 'GO'
END

--If it's not a production environment or the customer don't want to use the functionality of SQL server to get back to DB state to a particular time, you can set finally the recovery model to Simple:
--PRINT 'ALTER DATABASE [' + @dbname + '] SET RECOVERY SIMPLE'
--PRINT 'GO'
PRINT ''
END

FETCH NEXT FROM curDatabases INTO @dbname, @dbid,@dbRecoveryType
END

CLOSE curDatabases
DEALLOCATE curDatabases

Kind regards,

Olivier