Export (0) Print
Expand All

Submit a Database Restore Request

Updated: September 10, 2014

This topic describes the necessary steps to making a restore request and monitoring the status of the restore request.

Before You Begin

Restrictions and Limitations

  • Only Basic, Standard, and Premium service tiers support Point in Time Restore and Geo-Restore features.

  • The backup retention period varies based on the service tier. For more information on retention periods, see Azure SQL Database Backup and Restore. Requests to restore to a point in time outside of the supported retention period for the service tier will fail.

  • Geo-Restore uses the latest available full and differential backups to restore the database. Geo-Restore does not support restoring to a specific point in time.

  • A deleted database can only be restored to the point at which it was deleted.

Security

  • Only the administrator or co-administrator for the subscription can submit a restore request. This applies to both Point in Time Restore and Geo-Restore.

  • The server level principal login will be the owner of the restored database.

ImportantImportant
Database auditing is not automatically enabled on the restored database even if your original database had this option enabled. If you need auditing on your restored database you must enable auditing after the restore is complete. For more information on auditing for Azure SQL Database, see Database Audit.

Point in Time Restore a Live Database

Management Portal

  1. Sign in to the Azure Management Portal using your Microsoft account.

  2. From the Databases list, select the database you want to restore.

  3. At the bottom of the page in the command bar, click Restore. This launches the Specify Restore Settings dialog box.

  4. The Restore Point is used to specify the point in time to which your database should be restored. The restore point must be within the retention period supported by the database service tier and the Point in Time setting must be set to ON.

  5. Specify a new database name in the Database Name field.

  6. Click Submit to submit the restore request.

  7. Restore operations may take a long time to complete. You can monitor the status of the restore operation on the Databases list. Databases that are being restored are visible in the Databases list once the restore is in progress. The row is populated with the database settings and the status of the restore operation which is displayed as Restoring until the operation is completed.

    TipTip
    To avoid incurring unnecessary billing charges, if you no longer require the original database, you should delete it once the copy operation has completed and you have tested the new database.

PowerShell

  • Use the Start-AzureSqlDatabaseRestore cmdlet to request a point in time restore of the database.

    • Specify the source database.

    • Specify point in time for the restore.

    • Specify the name for the new database.

    Sample syntax:

    PS C:\>$operation = Start-AzureSqlDatabaseRestore –SourceServerName "a234b56" –SourceDatabaseName "mydatabase" –TargetDatabaseName "mydatabaserestored" –PointInTime "2013-01-01 06:00:00"
    
    

    For more information, see Start-AzureSqlDatabaseRestore.

Restore a Deleted Database

  1. Sign in to the Azure Management Portal using your Microsoft account.

  2. Click on the Deleted Databases list, which includes a list of Restorable Deleted Databases. Select the database you want to restore.

  3. At the bottom of the page in the command bar, click Restore.

  4. Specify a database name for the new database in the Database Name field.

  5. Click Submit to submit the restore request.

  6. Restore operations may take a long time to complete. You can monitor the status of the restore operation on the Databases list. A new row is added for each restore operation. Databases that are being restored are visible in the Databases list once the restore is in progress. The row is populated with the database settings and the status of the restore operation which is displayed as Restoring until the operation is completed.

Geo-Restore

  1. Sign in to Azure Management Portal using your Microsoft account.

  2. From the Databases list, select the database you want to restore.

  3. At the bottom of the page in the command bar, click Restore. This launches the Specify Restore Settings dialog box.

  4. Specify the source server and the target server names. Source server is the database server where your source database is hosted; target server is the name of the server you want to restore. Verify the Point in Time setting is OFF.

  5. Specify a new database name in the Database Name field.

  6. Click Submit to submit the restore request.

Monitoring Restore Operations Using Dynamic Management Views

The sys.dm_operation_status dynamic management view (DMV) can be used to monitor the restore operation. The state column returned when you query the DMV includes the status of the restore request: COMPLETED, FAILED, and CANCELLED. For more information, see sys.dm_operation_status.

Community Additions

ADD
Show:
© 2014 Microsoft