Azure-docs: Sync Frequency

[Tiberriver256]

If I set my frequency to once a day. What time of day does it schedule the job to be executed?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: e8439fa3-ed6f-94cd-107c-c2b00fa97d1a
• Version Independent ID: 0abf3b39-4fd0-a920-e5d2-8ae2bac650cd
• Content: Set up Azure SQL Data Sync
• Content Source: articles/sql-database/sql-database-get-started-sql-data-sync.md
• Service: sql-database
• Sub-service: data-movement
• GitHub Login: @allenwux
• Microsoft Alias: xiwu

[Mike-Ubezzi-MSFT]

@Tiberriver256 I believe the sync frequency is roughly the selected interval period from the time the configuration is saved. As an example, if you select every 24 hours the next sync will be within 24 hours from the completion of the previous sync. That previous sync will initiate shortly after the initial configuration is established and saved. Let me confirm this.

[Mike-Ubezzi-MSFT]

@Tiberriver256 Apologies for the delay on getting you a response. Are you syncing Azure SQL Database to Azure SQL Database or are you invoking the Sync Agent for an on-premise to Azure SQL Database instance? In Azure to Azure sync, there is no schedule and only a manual invoke button, when set-up entirely through the portal. So, I am looking for some more detail about your sync scenario. Thank you!

[Tiberriver256]

Azure SQL to Azure SQL. It appears the first answer of it being every 24 hours from when you start the sync is correct from the logs.

[Mike-Ubezzi-MSFT]

@Tiberriver256 Notice how the subsequent day sync starts a few seconds later than the completion time the previous day. The sync start will drift forward in time with each day the sync is run. Is this sufficient to answer your question?

[Tiberriver256]

Yes, thank you. Can this be added to the docs?

[Mike-Ubezzi-MSFT]

Let me forward this to the content owner as a doc-enhancement as there is nowhere that this is detailed.

[Tiberriver256]

In case others stumble on this over time, I opened a User Voice for the ability to schedule the specific time:
https://feedback.azure.com/forums/217321-sql-database/suggestions/38799886-schedule-time-for-azure-sql-data-sync

[stevestein]

reassign:stevestein

[stevestein]

@Tiberriver256 - thanks for raising this issue. The article has been updated.

Thanks!

please-close