| Plugin Title | DB Restorable |
| Cloud | AZURE |
| Category | SQL Databases |
| Description | Ensures SQL Database instances can be restored to a recent point |
| More Info | Automated backups of SQL databases with recent restore points help ensure that database recovery operations can occur without significant data loss. |
| AZURE Link | https://docs.microsoft.com/en-us/azure/sql-database/sql-database-recovery-using-backups |
| Recommended Action | Ensure that each SQL database has automated backups configured with a sufficient retention period and that the last known backup operation completes successfully. |
- Log into the Microsoft Azure Management Console.
- Select the "Search resources, services, and docs" option at the top and search for SQL databases.
- On the "SQL database" page, select the SQL database that needs to be examine.
- On the selected "SQL database" page, scroll down the left navigation panel and select "Overview" option.
- On the "Overview" page, click on the "Restore" option at the top.
- On the "Restore" page, scroll down and check the "Earliest restore point" under the "Point-in-time" and if it's showing "No restore point available" then the selected "SQL database" cannot be restored to a recent point.
- Repeat steps number 2 - 6 to verify other "SQL databases" in the account.
- Navigate to "SQL databases", on the "SQL database" page select the "SQL database", scroll down the left navigation panel and choose "Overview."
- Click on the "Restore" option at the top.
- On the "Restore" page, select the "Source", "Restore Point" and "Pricing tier" as per the requirements and click on "OK" button at the bottom.
- Repeat steps number 8 - 10 to ensure that each SQL database has automated backups configured with a sufficient retention period and that the last known backup operation completes successfully.
