Scheduled Backup in Azure SQL Database

0

I know that the backups in SQL Azure are automatic, but how can I make a configuration in them? Schedule for a particular time?

    
asked by anonymous 06.10.2017 / 15:39

1 answer

0

It is NOT possible to configure the frequency of backups in Azure SQL. I confess that I do not see the need for such, since it occurs back every 5-10 minutes. See the documentation how often backups occur .

  

Complete database backups occur weekly, the   Differential database backups usually occur at times   and transaction log backups typically occur   every 5 to 10 minutes.

This means that you can restore the data to the nearest 5-10 minute intervals.

The only configuration that can be done is with respect to time the backups are stored . Today they follow the following rule:

  • The Basic service layer is 7 days.
  • Standard service layer is 35 days.
  • Premium service tier is 35 days.

But one can extend the retention period for backups . This allows you to extend the internal retention period from 35 days to up to 10 years. For more information, see Long-Term Retention .

    
09.10.2017 / 09:08