Recommended sizing for point in time restore Azure SQL

Joseph S. Bartolome 21 Reputation points


What is the recommended sizing for point in time restore in Azure SQL? I am doing a costing for a project and plan to use Azure SQL general purpose database.


Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bjoern Peters 8,611 Reputation points

    What kind of Azure SQL do you want to deploy?

    Azure SQL Server in a VM
    Azure SQL Database
    Azure SQL Managed Instance

    In the case of a PiT on an Azure SQL VM, there are no differences between Azure and your data center, you are responsible for setting up the backup for your SQL Server.
    In the case of a PiT on an Azure SQL DB/MI, the service has the backup/restore included, and it is scheduled automatically => you can't change it.

    There is no correlation between sizing and PiT restores.