How do I permanently delete Azure Arc databases? The resource of Azure Arc databases keep reverting back to live.

Question

We have on-prem SQL server and Azure Arc is enabled then around 50 databases were connected. Then, this is getting too much charges so I tried to delete them then it kept reverting back.

I navigated through and noticed from Resources --> activity log. Found the following:

SqlServerDatabases_Update - it is initiated by "Azure Arc Data Processing Services". How do I delete this initiator?

Is it happening from the server that initiates the update? or is it within the Azure?

I also deleted Azure Arc - SQL server from Resource group, but that keeps reverting back too.

Please help.

Answer 1

Hi @Youngjin Jo

This could be due to the Azure Arc Data Controller continuously syncing with your on-premises SQL Server.

Here are a few steps you can take:

1. Disable Auto Sync: Navigate to the Azure Arc Data Controller and disable the auto-sync feature. This will stop the controller from automatically syncing with your on-premises SQL Server and recreating the databases.
2. Delete the Databases: After disabling auto-sync, try deleting the databases again. Check the box that says “Delete permanently” to ensure the databases are not just being de-provisioned but are being deleted.
3. Check the Initiator: The SqlServerDatabases_Update The operation initiated by “Azure Arc Data Processing Services” is likely the recreating the databases. If disabling auto-sync doesn’t stop this, you may need to investigate further into this service.
4. Delete the SQL Server Resource: If all else fails, you might need to delete the SQL Server resource from the Azure Arc—SQL Server in the Resource group. However, this is a more drastic step and should only be taken if absolutely necessary.

If this answers your question, please click Accept Answer and Yes if this answer was helpful. Doing so would help other community members with similar issues identify the solution. I highly appreciate your contribution to the community.