As you know the beauty of the PaaS is you don’t have anymore to manage the underlying infrastructure (patching OS for example) as this the responsibility of the cloud provider.
Well, while this is very interesting you lose a little bit of control, especially when it comes to maintenance.
Well, you can now manage the maintenance window for your SQL Managed Instance and SQL Database.
By default, the maintenance window is set between 5 PM and 8 AM every day (based on local time of your Azure region).
You now have the ability to define a different maintenance window between the 2 options:
- 10:00 PM to 6:00 AM local time, Monday – Thursday
- 10:00 PM to 6:00 AM local time, Friday – Sunday
This can be managed either during the database or managed instance creation and on existing ones.
In addition, you can also configure the alerting option – this is in preview – (only for existing database or managed instance; this is not available during the creation) to be alerted on planned maintenance 24 hours in advance, under the Maintenance blade.
This option will redirect you to the Service Health\Health Alert blade; you can configure the maintenance alert by following the documentation available here https://docs.microsoft.com/en-us/azure/azure-sql/database/advance-notifications