Assistance Needed: Azure SQL Server Database Backups Status and Calculations Formula Retrieval

Question

Assistance Needed: Azure SQL Server Database Backups Status and Calculations Formula Retrieval

youssef arhal 0

Hello, Could you assist me in obtaining explanations from Azure regarding the status of SQL Server database backups and the assurances provided by Azure regarding the availability of these backups? I've noticed that when accessing SQL Server in the backup section, I can't find any information indicating whether the backup was successful or failed. Additionally, I would like to know how to retrieve the calculation formula to estimate execution time based on database size. Thanks in advance,

1 answer

Your answer

Answer 1

RahulRandive 10,486 Volunteer Moderator

Hi @youssef arhal

For Azure SQL Database, you can find the Earliest PITR restore point for particular database. Navigate to your logical SQL server and locate the backup section, where you'll find the earliest point-in-time restore (PITR) option.

User's image

Azure SQL Database automatically retains backups for PITR within the last 7 days by default, ensuring databases are restorable to any point within this period. Additionally, you can perform PITR at any desired time within the retention policy you've configured (ranging from 7 to 35 days) for assurances. Yes, the portal doesn't offer a specific backup status feature, as the backups are managed automatically by the Azure backup service. Reference document- Automated backups in Azure SQL DatabaseThank you!

youssef arhal 0 Reputation points

2024-02-22T20:18:28.6133333+00:00

Thanks @RahulRandive , So, is there a way to determine whether the backup has been successful or has failed? As for the second question, is there a calculation formula that allows us to determine the execution time of the backup in relation to the size of the SQL databases?
RahulRandive 10,486 Reputation points Volunteer Moderator

2024-02-23T03:35:06.6+00:00

Hi youssef arhal,

Both questions are answered with a "No." As I mentioned, Microsoft Azure's backup service handles backups, and there isn't a specific way to determine if a backup has succeeded or failed.

Additionally, there's no formula to calculate execution time, but generally, larger databases take more time to back up. However, the SQL Database service determines the exact timing of all backups to balance system workload, minimizing performance impact during backups, so backups mostly do not hamper any performance.

I hope the answers are helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.

Thank you!

Share via

Assistance Needed: Azure SQL Server Database Backups Status and Calculations Formula Retrieval

1 answer

Your answer