Page verify option

Name:	Page verify option
Platform:	Sqlserver
Category:	Maintenance
Premium package:	Maintenance package
Description:	This job checks whether PAGE_VERIFY database option is set to CHECKSUM. This helps provide a high level of data-file integrity.
Long description:	This job checks whether PAGE_VERIFY database option is set to CHECKSUM. When CHECKSUM is enabled for the PAGE_VERIFY database option, the SQL Server Database Engine calculates a checksum over the contents of the whole page, and stores the value in the page header when a page is written to disk. This helps provide a high level of data-file integrity.
Version:	1.1
Default schedule:	10 7,12 * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2008’ & hasengine=‘YES’

Parameters
Name	Default value	Description
ignore databases	model	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 value (ALARM – 2, WARNING – 1, or OK – 0) when “Page verify option” is not set to parameter value “verify option” (default CHECKSUP).
verify option	CHECKSUM	Page verify option set on database to be check by this procedure.
change settings	NO	If set to “YES” the procedure will change the page verify option according to “verify option” parameter value.

Feedback