An Azure relational database service.
Data Sync - Adding On Prem DB is "Add Failed"
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