Backup and Restore of Azure SQL Database

Many people feel or see difficulty about Azure SQL Database backup and restoration.

Always keep in mind Azure take backups of your Azure SQL Database automatically and you cannot see that backups in the form files, you are seeing only your SQL Database file or instance.

Azure take care of your database according to following criteria.

• A full backup after every week.
• Differential backups after every few hours or a day.
• Transaction log backups after every 5-10 minutes.

Whenever you create your database, Azure will automatically start protection of your database. Azure take 1st backup of your database within 30 minutes after your database creation.

Now the next question is

How and when we restore our SQL database backup?

first understand this, Azure is giving you three-tier structure plan

• Basic
• Standard
• Premium

In the basic plan, we can do restoration within 7 days.

In standard and Premium plan we can do restoration within 35 days.

For restoration

Select your database (here my database is testing)

Click on restore.

Select your previous date and time on which you want to restore your database and then click on OK.

It will take a few minutes

You can check your progress in AZURE notification icon.

After successfully restoring you can see your restore database in SQL DATABASES

and as well as in your SQL SERVER also