Evaluate and standardize database recovery time

evaluate-recovery-time.sql

SELECT
	[name] AS database_name, target_recovery_time_in_seconds
,	CASE
	WHEN target_recovery_time_in_seconds = 60
	THEN NULL
	ELSE	'ALTER DATABASE [' + [name] + ']'
		+	' SET TARGET_RECOVERY_TIME = 60 SECONDS;'
	END	AS alter_command
FROM	sys.databases
WHERE	[name] NOT IN ('master','model','msdb','tempdb')
  AND	state_desc = 'ONLINE'
ORDER BY [name]