Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in Azure by (4k points)
Is there any way I can use Azure SQL DB, periodically restore it and maintain a backup history?

1 Answer

0 votes
by (9.6k points)

Azure creates a separate new database while restoring one. The new database may be renamed to the old one to make it The restored databases are automatically stored at a Geo replicated Blob Storage. 

Database replacement is used to periodically restore a Database and also maintain the backup history. 

If the original database is intended to be restored exactly how it is, you can specify the service tier and compute the size of the original database. ALTER DATABASE command may be used to rename the restored database to the original database.  

To get a better understanding, you can check this Azure Administrator certification out. 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jan 29, 2021 in Azure by chandra (29.3k points)

Browse Categories

...