question

TimR-9041 avatar image
0 Votes"
TimR-9041 asked AmeliaGu-msft edited

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

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

azure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

pituach avatar image
0 Votes"
pituach answered

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://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management?tabs=azure-powershell#management-modes


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.