You can accidentally remove a database, or you might remove a database and figure out that you still need it later on. This can be a tough situation. However, Microsoft Azure supports database recovery, even in the case of deletion. (The SQL Server on which the database was built cannot have been deleted; at the time of writing this book, there was no support for the recovery of deleted SQL Servers.)
To restore a deleted database, follow these steps:
- Navigate to SQL Servers and select the server in which the deleted database was built.
- Scroll down to Deleted databases in the SQL server blade, as shown in the following screenshot:
- Select the database that you want to restore, and name it as you wish, considering that you cannot provide the name of an existing database that is already running on the same SQL Server (but you can give it its old name), as shown in the following screenshot:
- Once you are done, click on OK, and it will start the restoration process.