Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Professional Azure SQL Database Administration

You're reading from   Professional Azure SQL Database Administration Equip yourself with the skills you need to manage and maintain your SQL databases on the Microsoft cloud

Arrow left icon
Product type Paperback
Published in Jul 2018
Publisher Packt
ISBN-13 9781789538854
Length 398 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Author (1):
Arrow left icon
Ahmad Osama Ahmad Osama
Author Profile Icon Ahmad Osama
Ahmad Osama
Arrow right icon
View More author details
Toc

Automatic Backups

Microsoft provides automated backups for Azure SQL Databases.

Automatic backup consists of full, differential, and log backups. The first automatic full backup is performed immediately after the database is provisioned. The differential is scheduled to occur every hour, and transaction log backups are scheduled for every 5-10 minutes. The full backup is scheduled for once a week:

Automatic Backups

Figure 3.1: Automatic Backups

Note

Automatic backups are inaccessible. You can't download or do a manual restore from an automatic backup.

However, you can use automatic backup to restore the database using the Azure portal, Azure CLI, PowerShell, Azure, and .Net SDK.

Backup Storage

Microsoft gives you free backup storage which is double the size of your maximum provisioned database storage. For example, if you have a standard Azure SQL Database of size 100 GB, you get 200 GB of free backup storage. You can control the free backup storage size by limiting the retention period of the backups...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime