can we recover the deleted azure sql database of size 760GB?

You may need to choose a higher SLO that offers adequate storage capacity for your database. For instance, the ‘SQLDB_GP_Gen5_6’ SLO supports up to 1,536 GB (1.5 TB) of storage, which would accommodate your database size.

After the restoration, if you find that the database contains unused space, you can perform a shrink operation to reclaim it. This can be done using the DBCC SHRINKDATABASE command in T-SQL.

So once you reclaim the unused space, you may consider scaling down to a lower SLO that aligns with your actual storage needs, which can help in optimizing costs.

Don’t forget that higher SLOs come with increased costs so you may need to balance the need for storage and performance with budget considerations.

Some links to help you :

learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql

learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql

github.com/MicrosoftDocs/sql-docs/blob/live/azure-sql/database/resource-limits-logical-server.md

Read more here: Source link