Shrink transaction logs

Name:	Shrink transaction logs
Platform:	Sqlserver
Category:	Maintenance
Description:	This procedure shrinks transaction log files which are detected by ‘Transaction log size check’ alert which cheks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size).
Long description:	This procedure shrinks transaction log files which are detected by ‘Transaction log size check’ alert which cheks the size of the transaction log (log file(s) size), and compares it to the database size (data file(s) size). Only transaction logs with one file can be shrinked.
Version:	1.2
Default schedule:	10 5 6 *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ \| engine_edition = ‘Azure SQL Managed Instance’)

Feedback