Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Azure recover deleted database

I've accidentally deleted my Azure web site which was linked to database, and now my Database is gone.

Is there any way I can recover data from database ?

like image 869
hyperN Avatar asked Apr 16 '14 09:04

hyperN


People also ask

Can I restore a deleted database?

Scan and restore deleted database file. All you need is to search, test and find file recovery software for help. EaseUS Data Recovery Wizard supports fully scan your SQL Server hard drive on a local computer and restore the deleted database file - MDF or NDF files in 3 steps: Step 1.

Can we restore deleted Azure SQL Server?

In the event a database is deleted, Azure SQL Database allows you to restore the deleted database to the point in time of deletion.

How do I restore a deleted SQL database?

How do I get back SQL database deleted objects? You simply run the SQL recovery software and add the SQL database MDF or NDF file in the control panel. This tool quickly scans your data and recovers SQL database objects and shows a preview of deleted objects in red color.


1 Answers

In the Azure Portal:

  • On the left menu, click 'All Resources'
  • Select the Sql Server from which the database was deleted
  • Scroll down to the 'Operations' section
  • Click 'Deleted databases'
  • Select the database to restore
  • Review the information and click OK

Deleted databases

Note that restoring a backup from the list can still fail if it's outside the retention period for your pricing tier.

like image 121
Bart Jolling Avatar answered Sep 27 '22 20:09

Bart Jolling