My question is very simple. I'm configuring Point-in-time Restore for an Azure SQL Database. Does the size of the storage data must be the same as the size of the database?
i.e. If my storage data is 100GB, does my Point-in-time Restore need to be 100GB too?
Thank you!
No, the size of the storage data does not have to be the same as the size of the database for Point-in-time Restore in Azure SQL Database.
Point-in-time Restore allows you to restore a database to a specific point in time within the retention period. The retention period is the time period during which you can restore the database. The size of the storage data depends on the amount of data changes during the retention period.
For more information, you can refer to the "Restore a database from a backup in Azure SQL Database" article.