Backups, replication, and failover groups

- [Instructor] Azure SQL database is a fully-managed solution and there are two main benefits to this arrangement. The first is backup maintenance and retention. Backups are automatically made and saved to geo-redundant Azure blob storage for 7 to 35 days, depending on your chosen service tier. With a long-term service agreement, this can be extended for up to 10 years. The backup frequency is based on a schedule with full backups taken every week, differential backups every 12 hours and log backups taken every 5 to 10 minutes. This backup frequency allows full point-in-time restores to any point within the current retention period. Now because Azure is managing these backups, manual backups initiated on the server through traditional T-SQL commands will be ignored. Restored procedures in Azure SQL database are also a little bit different than in an on-premises SQL Server instance. Again, T-SQL restore commands sent to the server will be denied and the process must be performed…