-1
I know that the backups in SQL Azure are automatic, but how can I make a configuration in them? Schedule for a certain time?
1 answer
0
You CANNOT configure the frequency of backups in Azure SQL. I confess that I see no need for this, since it occurs back every 5-10 minutes. See excerpt from the documentation on how often backups occur.
Full database backups occur weekly, the differential database backups usually occur at times and transaction log backups usually occur to every 5 to 10 minutes.
This means that one can restore the data accurately at intervals of 5-10 minutes.
The only configuration that can be made is with respect to time that backups are stored. Today they follow the following rule:
- Basic service layer is 7 days.
- Standard service layer is 35 days.
- Premium service layer is 35 days.
But you can extend the retention period of 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.
Browser other questions tagged sql windows-azure backup azure-sql
You are not signed in. Login or sign up in order to post.