Share via

Re-registering SQL with SQL Iaas agent on VM cause downtime?

TimR 1 Reputation point
2021-03-17T16:17:14.977+00:00

Does anyone know if re-registering sql server with the sql IaaS agent on a VM will cause any downtime on the VM? We recently downgraded the edition on a VM and removed it from the IaaS agent. Now that we have the proper version of SQL installed, it looks like it needs to be re-registered with the agent so we can update the billing info on the VM. Just want to make sure I'm aware of what may occur, if anything to the running status of the VM during this process. Any insight would be appreicated. TimR

SQL Server on Azure Virtual Machines
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ronen Ariely 15,221 Reputation points
    2021-03-17T16:43:01.25+00:00

    Good day Tim,

    There are three management modes for SQL Server IaaS Agent: Lightweight which does not restart the SQL Server service, Full mode which requires a restart of the SQL Server service, and NoAgent which like the first one does not restart the SQL Server service.

    You can get more details in this doc:
    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management?tabs=azure-powershell#management-modes

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.