Most people think they no longer have to worry about backups once they move to the cloud. However, there’s a good chance the default settings aren’t enough and may violate company policy or government regulations. In this session, we will cover why and how you can manage backups in Azure.

Do you know what the default backup settings for Azure SQL Database are? What is the maximum point-in-time backup retention you can set, and what happens if you need to retain the backup for years due to regulatory requirements? What kind of redundancies do you have for backup files? What restore capabilities do you have? How do you monitor backup costs? How do you test your restore to ensure a good backup, since "Your backup is as good as your restore."

If you need to know the answers to these questions, this session is for you. I will answer all these questions and more with a live demo of setting up retention, restoring cross-region from Geo-Redundant backup, and querying backup consumption while calculating cost.

Prerequisite: Basic understanding of backup and restore of SQL Server Databases

Goals:
1. Understand the default Azure SQL Database backup settings for retention and redundancy.
2. How to change those settings to comply with your business and regulatory requirements
3. How to restore cross region using Geo-Redundant backup