Procedure dbo.DatabaseIntegrityCheck, Line 1017 The value for the parameter @AvailabilityGroups is not supported

[abdulsayyad83]

Description of the issue

SQL Server version and edition Microsoft SQL Server 2017 (RTM-CU29-GDR) (KB5014553) - 14.0.3445.2 (X64) May 29 2022 12:36:31 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Datacenter 10.0 (Build 17763: ) (Hypervisor)

Version of the script 2022-12-03 17:23:44

What command are you executing?

@Databases nvarchar(max) = 'USER_DATABASES', @CheckCommands nvarchar(max) = 'CHECKDB', @PhysicalOnly nvarchar(max) = 'N', @DataPurity nvarchar(max) = 'N', @NoIndex nvarchar(max) = 'Y', @ExtendedLogicalChecks nvarchar(max) = 'N', @TabLock nvarchar(max) = 'N', @FileGroups nvarchar(max) = NULL, @Objects nvarchar(max) = NULL, @MaxDOP int = NULL, @AvailabilityGroups nvarchar(max) = 'ALL', @AvailabilityGroupReplicas nvarchar(max) = 'ALL', @Updateability nvarchar(max) = 'ALL', @TimeLimit int = NULL, @LockTimeout int = NULL, @LockMessageSeverity int = 16, @StringDelimiter nvarchar(max) = ',', @DatabaseOrder nvarchar(max) = 'DATABASE_NAME_ASC', @DatabasesInParallel nvarchar(max) = 'N', @LogToTable nvarchar(max) = 'Y', @Execute nvarchar(max) = 'Y' What output are you getting? Message Executed as user: AD\SQLServicesQ. Date and time: 2023-02-18 10:00:01 Server: XXXXX Version: 14.0.3445.2 Edition: Standard Edition (64-bit) Platform: Windows Procedure: [dbUtilities].[dbo].[DatabaseIntegrityCheck] Parameters: @Databases = 'USER_DATABASES', @CheckCommands = 'CHECKDB', @PhysicalOnly = 'N', @DataPurity = 'N', @NoIndex = 'Y', @ExtendedLogicalChecks = 'N', @TabLock = 'N', @FileGroups = NULL, @Objects = NULL, @MaxDOP = NULL, @AvailabilityGroups = 'ALL', @AvailabilityGroupReplicas = 'ALL', @Updateability = 'ALL', @TimeLimit = NULL, @LockTimeout = NULL, @LockMessageSeverity = 16, @StringDelimiter = ',', @DatabaseOrder = 'DATABASE_NAME_ASC', @DatabasesInParallel = 'N', @LogToTable = 'Y', @Execute = 'Y' Version: 2022-12-03 17:23:44 Source: https://ola.hallengren.com Msg 50000, Level 16, State 1, Server XXXXX , Procedure dbo.DatabaseIntegrityCheck, Line 1017 The value for the parameter @AvailabilityGroups is not supported. Msg 50000, Level 16, State 3, Server XXXXX, Procedure dbo.DatabaseIntegrityCheck, Line 1017 You can only specify one of the parameters @Databases and @AvailabilityGroups. Msg 50000, Level 16, State 1, Server XXXX, Procedure dbo.DatabaseIntegrityCheck, Line 1017 The documentation is available at https://ola.hallengren.com/sql-server-integrity-check.html. Date and time: 2023-02-18 10:00:01 . Process Exit Code 1. The step failed.

[Stiffboard]

Message also says: You can only specify one of the parameters @databases and @AvailabilityGroups. That will give you all possibilities??

[olahallengren]

This is a by-design limitation.