SQL Databases

DB Not Restorable

Risk Level: Low

Description: 

This plugin makes it possible to restore SQL Database instances to a previous state. SQL database backups with current restoration points assist ensure that database recovery procedures can be performed with little data loss. SQL Server Standard and Enterprise versions running on a Windows VM in Azure are automatically backed up using Automated Backup. 

PingSafe strongly recommends ensuring that each SQL database has automated backups configured with a sufficient retention period and that the last known backup operation completes successfully.

About the Service :

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that takes care of most database maintenance tasks including updating, patching, backups, and monitoring without the need for human intervention. You may develop a highly available and high-performance data storage layer for Azure apps and solutions with Azure SQL Database.

Impact : 

To prevent application or user mistakes, such as unintended data insertions or deletions, we should back up our SQL Server databases. It's crucial in this case to be able to return to a precise point in time. Automated backups provide guaranteed protection against data loss or physical data corruption.

Steps to reproduce :

  1. Sign in to your Azure portal with your Azure account.
    https://portal.azure.com/#home 
  2. Navigate to Azure’s All Resources.
  3. In the Type filter select the value as SQL Servers and click Apply.
  4. Next, select the database under SQL Databases that you want to examine.

  5. Click on Restore and then navigate to the Source Detail’s Earliest restore point.
  6. Since it is disabled that means that the database is not restorable.
  7. Repeat the same steps for other servers as well.

Steps for remediation :

  1. Sign in to your Azure portal with your Azure account.
    https://portal.azure.com/#home 
  2. Navigate to Azure’s All Resources.
  3. In the Type filter select the value as SQL Servers and click Apply.
  4. Next, select the database under SQL Databases that you want to examine.

  5. Click on Restore and then navigate to the Source Detail’s Earliest restore point.
  6. Since it is disabled that means that the database is not restorable.
  7. Click on Review + create and a backup for restoration will be created.
  8. Repeat the same steps for other servers as well.

References :

Please feel free to reach out to support@pingsafe.ai with any questions that you may have.

Thanks

PingSafe Support