Thursday, 2 April 2015

How to Restore Azure SQL DataBase

Hello Folks,

Microsoft Azure SQL DataBase has built-in support for backup and self service point time of restore DataBases based Azure Subscriptions this can be allowed only for Basic, Standard, Premium and there is no restore option for Web and Business subscriptions.

The Backup retension period also based on the Subscription.

For Basic - 7 days, Standard - 14 days, Premium - 35 days.

Now creating the test DataBase in Azure and am deleting the DataBase.




There is an option of Restore in Bottom panel



Click on that, it will open a window for typing the DataBase name.





 Type your deleted DataBase name and Click on Ok.







Now the DataBase is online.





for more information about Azure SQL DataBase Baup and Restore read this Document.





No comments:

Post a Comment