Azure SQL VM Patch installation though Automation account , update management

  • Hi All,

    Is it possible to apply SQL cummulatative update and OS CU at time by include the KB details in update management.

    Regards,
    Shivrudra W

  • @shivrudra:

    Using Automated patching, it is possible to apply both SQL Server updates and Windows updates Azure. Automated Patching establishes a maintenance window for an Azure virtual machine running SQL Server. Automated Updates can only be installed during this maintenance window.

    For SQL Server, this restriction ensures that system updates and any associated restarts occur at the best possible time for the database VMs and does not even required restarts. Sometimes it depends on the region where your machine is located.

    However, it is important to note that only Windows and SQL Server updates marked as Important or Critical are installed by Automated Patching.

    If you have any other SQL Server updates, such as service packs and cumulative updates that are not marked as Important or Critical, must be installed manually.

    More on this:

    https://learn.microsoft.com/en-us/azure/automation/automation-faq

    =======================================================================

  • Thank you for providing that information.

    Regards,
    Shivrudra W

  • Actually in Azure there two different feature for patching installation . 1. Automated patching and 2. update management from Atomation account.

    with Automation account , we can apply the specific KB on SQL server .

    Atomation Account > update management > schedule deployment > select machine > classification > include KB > maintenamce window.

    My question is though automation account , Is it possible to include both OS and SQL KB at time.

    Regards,
    Shivrudra W

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply