Share via

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

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 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 :(

    Was this answer helpful?

  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

    Was this answer helpful?

  3. Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
    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.

    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.