how to restore differential azure Sql database automatically

Ashutosh Prashar 0

Hello,

Please suggest best approach to restore differential azure sql database. Restore/data refresh required 1-2 times daily.

if we can do something using powershell/python and automation used for auto refresh.

I am familiar with azure data factory for refreshing table data periodically.

I am finding something from azure database side.

Thanks in advance

ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2024-05-01T13:15:36.3+00:00

Hi Ashutosh Prashar •,

Welcome to Microsoft Q&A forum.

As I understand, you want to know about restoration of Differential backup of Azure SQL Database through automation.

Yes you could make use of Azure Data Factory, or if we consider Azure SQL DB Backup retention, Differential backups can be configured to occur either once in 12 hours or once in 24 hours. A 24-hour differential backup frequency might increase the time required to restore the database, compared to the 12-hour frequency.

In the vCore model, the default frequency for differential backups is once in 12 hours. In the DTU model, the default frequency is once in 24 hours.

According to the DB configuration, it applies.

Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql

Let us know if this helps or you have queries.

Thanks
Ashutosh Prashar 0 Reputation points

2024-05-02T12:28:20.21+00:00
Hi Shakti, Thank you for response.

I created Database 1 (Main db) with "Zone-redundant backup storage" Backup storage redundancy. and Service tier - general purpose / compute tier - serverless.

Retention policies also configured/modified with PITR-7 Days | Diff backup frequency 24 hours

Please suggest, how we can start db sync/refresh for Database 2(2nd db) daily from Database1(Main db).

=>Database 1 & Database 2 both are azure sql database and available on same server within elastic pool.

also suggest, sync to other database (under data management) will work for above scenario.

Regards

ashutosh
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2024-05-03T05:44:47.9066667+00:00

Hi Ashutosh Prashar •,

Thanks for the reply with details.

Let me check and get back to you.
ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2024-05-06T04:16:47.2633333+00:00

Hi Ashutosh Prashar •,

This is to update you that response is still awaited from the internal team.

Thanks for your patience.

1 answer

ShaktiSingh-MSFT 13,826 Reputation points Microsoft Employee

2024-05-07T03:45:30.8566667+00:00

Hi Ashutosh Prashar •,

Thanks for your patience.

We have got the below reply from the internal team:

For daily refresh of entire database, recommended approach would be to automate (Azure automation) restoring from short term retention backups (Point In Time Restore).

Data sync is targeted towards subset of tables/columns and not ideal for synchronizing whole database, looks like you are already using ADF for table level sync.

Hope this helps.

Let us know if further queries.

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Share via

how to restore differential azure Sql database automatically

1 answer