• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

SEARCH BY TAGS: 

Please reload

RECENT POSTS: 

FOLLOW ME:

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle

Cloud Series: Restore Database in Azure

July 10, 2017

 

 

 

One of the great things about Azure is that backups are automated as part of the service.  Azure for SQL touts a 12 hour RTO and a 5 minute RPO for backups that are considered "in-region". 

 

The backup schedule is as follows:

Full: Weekly

Differential: Hourly

Transaction Log: 5 mins.

 

Retention Period of the backups depends on the tier that you have selected.  

Basic: 7 Days

Standard and Premium: 35 Days

 

The backups are also Geo-Replicated, which means that in the event of an outage in your region, the backups can be restored to another region that is still up. 

 

Perform a Restore via the Azure Portal

 

Select your database via the dashboard or navigate through the panes (or just use the search function!). 

 

 

 

 

Select Restore.

 

 

 

 

Give the restore a different name (note that you cannot overwrite an existing database). Make note of the  oldest restore point and select your Restore Point accordingly. I also made sure to use the basic pricing tier as this is a lab for myself. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Press Apply or OK, and you can watch the progress in the upper right hand corner. 

 

 

 

Once finished you can navigate to the Azure DB server or list of DB's and see the newly restored Database.  This entire process can also be done via powershell, which will be covered in a future post. 

 

 

 

Share on Facebook
Share on Twitter
Please reload