- Basic ```bash Connect-AzAccount -TenantId "TenantID" # Set the target subscription Set-AzContext -SubscriptionId "subscriptionId" ``` - Terminate the replication between primary replica and seondary replica ```bash # confirm the replication link Get-AzSqlDatabaseReplicationLink -DatabaseName db1 -PartnerResourceGroupName rg2 -ResourceGroupName MyResourceGroup -ServerName s1 # remove the replication link Remove-AzSqlDatabaseSecondary -DatabaseName db1 -PartnerResourceGroupName rg2 -PartnerServerName secondaryserver -ResourceGroupName myresourcegroup -ServerName s1 ``` - Private endpoint approval ```bash # Approve PE in storage account $rg = "RGName" $sa = "BlobAccountName" $saId = (Get-AzStorageAccount -ResourceGroupName $rg -Name $sa).Id $pec = Get-AzPrivateEndpointConnection -PrivateLinkResourceId $saId Approve-AzPrivateEndpointConnection -Name $pec.Name -ResourceGroupName $rg -ServiceName $sa -PrivateLinkResourceType "Microsoft.Storage/storageAccounts" # Approve PE in SQL logical server $rg = "RGName" $sqlServer = "ServerName" $pec = Get-AzPrivateEndpointConnection ` -PrivateLinkResourceId (Get-AzSqlServer -Name $sqlServer -ResourceGroupName $rg).ResourceId Approve-AzPrivateEndpointConnection ` -Name $pec.Name ` -ResourceGroupName $rg ` -ServiceName $sqlServer ` -PrivateLinkResourceType "Microsoft.Sql/servers"