Autoshrink settings

Name:	Autoshrink settings
Platform:	Sqlserver
Category:	Maintenance
Description:	Checks if all databases have auto-shrink turned off.
Long description:	Checks if all databases have auto-shrink turned off. Only ONLINE databases with the following properties are included: UserAccess = MULTI_USER, Updateability = READ_WRITE, IsInStandBy = 0, IsMergePublished = 0, IsPublished = 0 and IsSubscribed = 0.
Version:	1.5
Default schedule:	0 7 7 *
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’)

Parameters
Name	Default value	Description
ignore databases		List of databases (separated by comma) which will be ignored. You can use % (percent sign) to represent wild card characters.
return status	1	Return status (ALARM – 2, WARNING – 1, or OK – 0) when Auto shrink is turned ON.
turn OFF auto shrink	NO	If set to “YES” the alert will turn OFF the auto shrink settings.

Feedback