Cleanup Database logs

sqlcmd -H host -U user -P 'password'

Find recovery model

select NAME, RECOVERY_MODEL_DESC FROM sys.databases
GO

SELECT NAME, LOG_REUSE_WAIT_DESC FROM sys.databases
GO

DBCC SQLPERF(LOGSPACE)
DBCC LOGINFO
GO

SELECT NAME FROM SYS.MASTER_FILES WHERE type_desc = 'LOG'
GO

For SIMPLE recovery model

-- optional
BACKUP LOG dbname TO mypath
go

USE dbname
DBCC SHRINKFILE (dbname_log, 1)
GO

For FULL recovery model

USE dbname
ALTER DATABASE dbname SET RECOVERY SIMPLE
DBCC SHRINKFILE (dbname_log, 1)
ALTER DATABASE dbname SET RECOVERY FULL
GO