Question

You manage a mission-critical Azure SQL Database in the General Purpose tier. Compliance requires the ability to restore the database to any point within the previous 30 days. The database currently uses the default backup configuration. What must you do to meet this requirement?

Accepted Answer

Increase the point-in-time restore (PITR) retention period setting for the database to 30 days

Answer

Configure a long-term retention (LTR) policy with a weekly backup retained for 30 days

Answer

Create a SQL Agent job that runs BACKUP DATABASE with COPY_ONLY every night to Azure Blob Storage

Answer

Enable active geo-replication to a paired region so backups are retained for 30 days