/articles/sql-database/sql-database-restore-deleted-database-portal.md

https://gitlab.com/apachipa/azure-content · Markdown · 58 lines · 43 code · 15 blank · 0 comment · 0 complexity · eda76df3363d962654ad94741fca0e56 MD5 · raw file 

    

  1. <properties
    2. 

  2. 	pageTitle="Restore a deleted Azure SQL database (Azure Portal) | Microsoft Azure"
    3. 

  3. 	description="Restore a deleted Azure SQL database (Azure Portal)."
    4. 

  4. 	services="sql-database"
    5. 

  5. 	documentationCenter=""
    6. 

  6. 	authors="stevestein"
    7. 

  7. 	manager="jhubbard"
    8. 

  8. 	editor=""/>
    9. 

  9. 

  10. <tags
    11. 

  11. 	ms.service="sql-database"
    12. 

  12. 	ms.devlang="NA"
    13. 

  13. 	ms.date="06/09/2016"
    14. 

  14. 	ms.author="sstein"
    15. 

  15. 	ms.workload="data-management"
    16. 

  16. 	ms.topic="article"
    17. 

  17. 	ms.tgt_pltfrm="NA"/>
    18. 

  18. 

  19. 

  20. # Restore a deleted Azure SQL database using the Azure Portal
    21. 

  21. 

  22. > [AZURE.SELECTOR]
    23. 

  23. - [Overview](sql-database-restore-deleted-database.md)
    24. 

  24. - [Azure portal](sql-database-restore-deleted-database-portal.md)
    25. 

  25. - [PowerShell](sql-database-restore-deleted-database-powershell.md)
    26. 

  26. 

  27. ## Select the database to restore 
    28. 

  28. 

  29. To restore a database in the Azure Portal do the following:
    30. 

  30. 

  31. 1.	Open the [Azure Portal](https://portal.azure.com).
    32. 

  32. 2.  On the left side of the screen select **BROWSE** > **SQL servers**.
    33. 

  33. 3.  Navigate to the server with the deleted database you want to restore and select the server
    34. 

  34. 4.  Scroll down to the **operations** section of your server blade and select **Deleted databases**:
    35. 

  35. 	![Restore an Azure SQL database](./media/sql-database-restore-deleted-database-portal/restore-deleted-trashbin.png)
    36. 

  36. 5.  Select the deleted database you want to restore.
    37. 

  37. 6.  Specify a database name, and click Ok:
    38. 

  38. 

  39.     ![Restore an Azure SQL database](./media/sql-database-restore-deleted-database-portal/restore-deleted.png)
    40. 

  40. 

  41. ## Next steps
    42. 

  42. 

  43. - [Finalize your recovered Azure SQL Database](sql-database-recovered-finalize.md)
    44. 

  44. - [Restore a deleted database](sql-database-restore-deleted-database.md)
    45. 

  45. - [Restore a deleted database using PowerShell](sql-database-restore-deleted-database-powershell.md)
    46. 

  46. - [Restore a deleted database using the REST API](https://msdn.microsoft.com/library/azure/mt163685.aspx)
    47. 

  47. - [SQL Database automated backups](sql-database-automated-backups.md)
    48. 

  48. 

  49. ## Additional Resources
    50. 

  50. 

  51. - [Point-in-time restore](sql-database-point-in-time-restore.md)
    52. 

  52. - [Business Continuity Overview](sql-database-business-continuity.md)
    53. 

  53. - [Geo-Restore](sql-database-geo-restore.md)
    54. 

  54. - [Active-Geo-Replication](sql-database-geo-replication-overview.md)
    55. 

  55. - [Designing applications for cloud disaster recovery](sql-database-designing-cloud-solutions-for-disaster-recovery.md)
    56.