As a SQL Server user, you may have encountered the challenge of permanently losing backup files stored in Azure blob storage after deleting them from the container. In this blog post, we will explore a solution to this problem using the “Soft Delete” option in Azure Blob Storage.
What is Soft Delete?
The “Soft Delete” option is a critical feature available in Azure Blob Storage that allows you to recover deleted blob data. By enabling this feature, you can ensure that your SQL Server database backups are not permanently lost when deleted from the storage container.
Enabling Soft Delete in Azure Blob Storage
To enable the “Soft Delete” option, follow these steps:
- Access the Azure portal and navigate to the storage account details.
- Click on the “Soft delete” option under the “Blob service” section.
- Change the status of the feature to “Enabled”.
- Set a suitable retention period for the soft deleted data.
- Save the changes.
Once enabled, the “Soft Delete” option ensures that deleted blob data, including SQL Server database backups, can be recovered within the specified retention period.
Recovering Deleted SQL Server Database Backups
After enabling the “Soft Delete” option, you can easily recover deleted SQL Server database backups by following these steps:
- Access the storage container where the backups were stored.
- Click on the “Show deleted blobs” option.
- Select the deleted backup file you want to restore.
- Click on the “Undelete” option to restore the backup file.
With the “Soft Delete” option enabled, you can confidently recover deleted SQL Server database backups and avoid unnecessary trouble when you need to restore your data.
Considerations and Limitations
It’s important to note that the “Soft Delete” option only applies to blob data and blob snapshots. If you delete the storage account or storage container, the “Soft Delete” option will have no impact, and all objects will be permanently deleted.
To overcome this limitation, you can use the lock resources option in Azure to prevent accidental deletion of critical storage accounts or containers.
By leveraging the “Soft Delete” option in Azure Blob Storage, you can ensure the safety and recoverability of your SQL Server database backups, providing peace of mind and protection against data loss.