Backup of Azure Database
In Microsoft Azure Database, Restores can be done to the logical server hosting the database or to another region.
Local Restore
1. A new database on the same logical server recovered to specified point in time.
2. A database on the same logical server recovered to the deletion time.
3. you cannot overwrite an existing database.
Note : If you want to replace a database with a restored copy, you can rename the orignal and then rename the restored database.
Geo Restore
1. A new database on any server on any region up to the latest geo-replicated backup.
2. Full and differentials are geo-replicated.
Note : Geo-Restores have an 1hour RPO due to the possible delay in geo-replication.
Restore Demo
Lets restore database with name t1_portalRestore, here are the steps:
1. Click on the t1 database, then click on Restore button and provide the Restore point(UTC):
2. In notifications, it will show the progress:
3. Once its done, here it will show:
Thats it!!
I was suggested this blog by my cousin. I am not sure whether this post is written by him as no one else know
ReplyDeletesuch detailed about my trouble. You are wonderful! Thanks!
I am now not positive the place you're getting your info, however great topic.
ReplyDeleteI must spend some time finding out much more or working
out more. Thank you for excellent information I used to be in search of this information for my mission.
It's wonderful that you are getting thoughts from this paragraph as well as from our dialogue made
ReplyDeleteat this place.