/articles/sql-database/sql-database-point-in-time-restore-portal.md

https://gitlab.com/yeah568/azure-content · Markdown · 53 lines · 37 code · 16 blank · 0 comment · 0 complexity · f987bf6cf4dccb2039707f98eb1ed865 MD5 · raw file 

    

  1. <properties
    2. 

  2. 	pageTitle="Restore an Azure SQL Database to a previous point in time (Azure Portal) | Microsoft Azure"
    3. 

  3. 	description="Restore an Azure SQL Database to a previous point in time."
    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/17/2016"
    14. 

  14. 	ms.author="sstein"
    15. 

  15. 	ms.workload="sqldb-bcdr"
    16. 

  16. 	ms.topic="article"
    17. 

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

  18. 

  19. 

  20. # Restore an Azure SQL Database to a previous point in time with the Azure Portal
    21. 

  21. 

  22. 

  23. > [AZURE.SELECTOR]
    24. 

  24. - [Overview](sql-database-recovery-using-backups.md)
    25. 

  25. - [Point-In-Time Restore: PowerShell](sql-database-point-in-time-restore-powershell.md)
    26. 

  26. 

  27. This article shows you how to restore your database to an earlier point in time from [SQL Database automated backups](sql-database-automated-backups.md) using the Azure Portal.
    28. 

  28. 

  29. ## Select a database to restore to a previous point in time
    30. 

  30. 

  31. To restore a database in the Azure Portal do the following:
    32. 

  32. 

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

  34. 2.  On the left side of the screen select **BROWSE** > **SQL databases**.
    35. 

  35. 3.  Navigate to the database you want to restore and select it.
    36. 

  36. 4.  At the top of your database's blade, select **Restore**:
    37. 

    38. 

  38.     ![Restore an Azure SQL database](./media/sql-database-point-in-time-restore-portal/restore.png)
    39. 

  39. 

  40. 5.  Specify a database name, point in time and then click Ok:
    41. 

  41. 

  42.     ![Restore an Azure SQL database](./media/sql-database-point-in-time-restore-portal/restore-details.png)
    43. 

  43. 

  44. 

  45. 

  46. ## Next steps
    47. 

  47. 

  48. - For a business continuity overview, see [Business continuity overview](sql-database-business-continuity.md)
    49. 

  49. - To learn about Azure SQL Database automated backups, see [SQL Database automated backups](sql-database-automated-backups.md)
    50. 

  50. - To learn about business continuity design and recovery scenarios, see [Continuity scenarios](sql-database-business-continuity-scenarios.md)
    51. 

  51. - To learn about using automated backups for recovery, see [restore a database from the service-initiated backups](sql-database-recovery-using-backups.md)
    52. 

  52. - To learn about faster recovery options, see [Active-Geo-Replication](sql-database-geo-replication-overview.md)  
    53. 

  53. - To learn about using automated backups for archiving, see [database copy](sql-database-copy.md)
    54.