SQL Datbase Diff Backup

Question

SQL Datbase Diff Backup

Handian Sudianto 6,186

What mean from Diff backup Frequency? My value set to 12 hours, this mean the database will be backup every 12 hours?

User's image

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T03:41:45.26+00:00

Hi Handian Sudianto,

Just checking in to see if the below answer provided by @TP helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T03:41:45.26+00:00

Hi Handian Sudianto,

Just checking in to see if the below answer provided by @TP helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

TP 131.6K Volunteer Moderator

Hi,

Each week it performs a Full backup, plus every 12 or 24 hours (12 in your case) it does a Differential backup, plus approximately every 10 minutes it does log backup. When you do a restore it will automatically determine the combination of backups needed.

Below article explains in detail how backups work in Azure SQL Database:

Automated backups in Azure SQL Database

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

-TP

Handian Sudianto 6,186 Reputation points

2025-08-06T05:38:36.7833333+00:00

hi..

So how if we wan to restore to last 36 hours ago?
TP 131.6K Reputation points Volunteer Moderator

2025-08-06T05:56:39.85+00:00

So how if we wan to restore to last 36 hours ago?

First subtract 36 hours from current UTC time = August 4, 2025 05:57PM

Navigate to the database in portal, click Restore, choose Select source: Point-in-time, Restore point (UTC): August 4, 2025 5:57PM

Share via

SQL Datbase Diff Backup

0 additional answers

Your answer