dbWatch AS

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

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment