Yet another SQL Server enthusiast

2017-12-28

Azure SQL DB – Database backups

Filed under: Uncategorized — sa @ 2:59 AM

Azure SQL DB automatically creates full, differential and log backups.

First full database backup is created after database creation and all other backups are scheduled weekly. Generally speaking, differential backups are created every few hours and transaction log backups are created every 5 – 10 minutes. The exact schedule for database backups is automatically computed based on system workload.

The retention period for database backups depends on service tier thus: 7 days for Basic or 35 days for Standard/Premium tier.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: