Data Sync - Adding On Prem DB is "Add Failed"

Murugesh Perumal 0 Reputation points
2026-07-31T03:52:19.2166667+00:00

Adding On Prem DB is "Add Failed"

Failed to perform data sync operation: Cannot create sync member 'XXX_1' because the maximum number of on-premise database as sync member can be created under a sync group is 5 for Basic sync group, But i have only 2. Before it was 4 and those are deleted. Also when i check the number of members ,

PS /home/aaa> $Members = Get-AzSqlSyncMember `

-ResourceGroupName $ResourceGroup `
-ServerName $ServerName `
-DatabaseName $HubDatabase `
-SyncGroupName $SyncGroup

PS /home/murugesh>

PS /home/murugesh> $Members | Format-Table SyncMemberName, MemberDatabaseType, SyncDirection, SyncState, SqlServerDatabaseId -AutoSize

SyncMemberName MemberDatabaseType SyncDirection SyncState SqlServerDatabaseId


aaa_1 SqlServerDatabase OneWayMemberToHub SyncSucceeded aa91-eca9-4b58-ac32-2da7f3

Azure SQL Database

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.