4. Backups

Database backups are among the most important tasks a database administrator must perform. A good database backup strategy can help recovery from system outages, unwanted deletions or updates, database corruption issues, and other related issues.

This chapter will help you back up an Azure SQL Database and an Azure SQL Managed Instance. You'll learn about automated and manual backups, explore automated backup features, and perform the manual backup of an Azure SQL Managed Instance.

This chapter explores different backup and restore options, such as automated backups, transactional consistent backups, and manual backups. We will be covering the following topics:

  • Automatic backups
  • Optimizing backup storage cost
  • Configuring long-term ...

Get Professional Azure SQL Managed Database Administration - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.