Share via

Additional Cost for Verify Function in SQL DB Backups to Blob Storage

Jordan Algar 0 Reputation points
2024-06-06T20:53:53.0733333+00:00

I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and clarification. Can anyone offer insight on the extra Verify costs?

Azure SQL Database
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,563 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,128 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Adharsh Santhanam 2,310 Reputation points
    2024-06-07T04:14:43.0233333+00:00

    Hello @Jordan Algar It isn't exactly correct to say that using the VERIFY function will increase your cost by 10x. However, it's absolutely true that the VERIFY function is resource-intensive and thus can add to your overall cost since it depends on both the size of your backups and the frequency of verification. It's important to monitor resource usage like CPU, I/O etc. during the VERIFY operations.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments