ARM template for SQL Elastic Pool with maintenanceConfigurationId

Question

Hi All,

I have an issue with ARM template - I was willing to set non-default maintenanceConfigurationId, however I found only CLI call to retrieve available options. Is there any option to get it in ARM template and set for my Elastic Pool? Default maintenance window is 5PM-8AM , I would set FRI-SUN 10PM-6AM.

Could you please advise how to achieve this?

Answer 1

Hi @Jan Kosmala , welcome to Microsoft Q&A forum.

Can you try something like below:

"properties": {  
                "collation": "SQL_Latin1_General_CP1_CI_AS",  
                "maxSizeBytes": 34359738368,  
                "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",  
                "zoneRedundant": false,  
                "licenseType": "LicenseIncluded",  
                "readScale": "Disabled",  
                "requestedBackupStorageRedundancy": "Geo",  
                "maintenanceConfigurationId": "/subscriptions/xxxxxxxxxxxxxxxxxxxxxf/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_WestUS2_DB_2",  
                "isLedgerOn": false  
            }  

Just have the proper configuration id and subscription id. Above code uses 'SQL_WestUS2_DB_2' but you can try as per your region. Please let me know if this helps.