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:
- 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.
- 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.
- 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. - 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.