Unable to stop or delete SQL Sync groups

Mike Hook 1 Reputation point
2022-05-06T12:01:19.013+00:00

Hi,

I am trying to remove some sync groups in SQL Azure, however they are stuck in a progressing state and don't respond to any commands.

This is the subscription ID: 7e86ca72-6bd1-4f50-a078-23b4b1f3b691

The databases are:
db-rating-uat
db-rating-dev

The Sync group is:
SyncGroup1

Could you force stop / delete these sync groups for me please?

This is happening quite often and prevents us from deploying the databases until it is resolved.
Do you think it is because these databases and the sync targets are set to auto pause in Azure?

Azure SQL Database
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Alberto Morillo 33,421 Reputation points MVP
    2022-05-06T12:07:59.813+00:00

    My suggestion is to disable temporarily the SQL user you used to configure the hub database in the sync group. In that case, your sync group will not be able to connect to the hub database and the sync will fail.

    You can also temporarily rename one of the databases, and that will cause the sync group to not be able to connect and fail out the sync.

    0 comments No comments

  2. Mike Hook 1 Reputation point
    2022-05-06T12:23:45.027+00:00

    I've tried renaming the databases but it still shows as 'progressing'

    The logs doesn't have any messages since 8AM this morning so it seems to have gone into a bad place.

    Is there anything else I can do or do I need to raise an Azure support ticket to get someone to sort it out in the backend?

    Thanks,
    Mike


  3. Mike Hook 1 Reputation point
    2022-05-06T13:00:25.347+00:00

    They have actually deleted now, I guess it was doing something in the background and just took an absolute age to complete.

    Its really slowing down our deployment process the way it is currently :(