Wednesday, September 17, 2014

Azure SQL Database Backup and Restore

First connect database server and select database which you want to backup database and right click on the database, then go to tasks =>  Export Data-tier Application as bellow one

Figure 01

When click on Export Data-tier Application "Instruction" popup window will expose, then click next button

Figure 02




 Then sql server expose "Export setting" window, there give location for save database backup using browse button. then click next button.

Figure 03







 then click finish button when summary window will populate. as bellow showing

Figure 04




No comments:

Post a Comment