
Navigate to the Object Explorer window, expand the node and select the database that you want to export.The first step is to connect to the SQL Server instance.Now, easily we can take the backup of the Azure SQL database using built-in SSMS SQL Server Import and Export Wizard by following the below steps. Using SQL Server Import and Export Wizard

Check out the above section for more information. We have already discussed above, the steps to take backup of azure sql database using Azure portal. Well, there are multiple ways by which you can able to backup Azure SQL Database or download the Azure SQL Database to the local machine. How to backup Azure SQL Database to Local Machine Step-2: Click on your Azure SQL database you created. Follow the below steps to back up the Azure SQL database. Let’s discuss here, how to take backup of azure sql database from portal. When we are thinking of the way to take the backup of the Azure SQL database, there are many questions coming into our mind like How do I back up my Azure SQL Database?, how to take backup of SQL Azure database, How can I do It using the Azure Portal? Is there a way to achieve this using the portal? etc Backup Azure SQL database
