Deleted table restore

Question

Is it possible to recover the deleted table in azure database ? if yes please tell me how ?

Answer 1

Hi VIKAS GOLE,

Welcome to Microsoft Q&A forum.

As I understand, you want to know about restoration of Deleted Azure Database.

If the question is for Azure SQL Database, then you can restore a deleted database to the deletion time, or an earlier point in time, on the same server by using the Azure portal, the Azure CLI, Azure PowerShell, and the REST API.

Note:

If you delete a server, all of its databases and their PITR backups are also deleted. You can't restore a deleted server, and you can't restore the deleted databases from PITR backups. If you had configured LTR backups for those databases, you can use those backups to restore the databases to a different server.

To recover a deleted database to the deletion time by using the Azure portal, open the server's overview page and select Deleted databases. Select a deleted database that you want to restore, and then enter the name for the new database that will be created with data restored from the backup.

To restore a database by using the Azure CLI, see az sql db restore.

For a sample PowerShell script that shows how to restore a deleted database in Azure SQL Database, see Restore a database by using PowerShell.

To restore a database by using the REST API:

REST (createMode=Recovery)	Restores a database.
REST (createMode=Recovery)	Restores a database.
REST (createMode=Recovery)	Restores a database.
Get Create or Update Database Status	Returns the status during a restore operation.

Hope this helps.

Let us know if you have further queries or have a different ask.

Thanks

Answer 2

Thanks for the reply.

Please follow the steps mentioned here:

https://www.c-sharpcorner.com/article/how-to-recover-deleted-data-in-azure-sql-database/ using PITR.