Recently I had to create a backup procedure on my Windows Azure SQL Database. SQL Server Management Studio allows us to access to our SQL Databases and provides the user interfaces for creating backup files.
In this post we will understand:
- how to create a Azure SQL Database copy
- how to save a logical file backup on the cloud storage
- how to restore the logical file on a new Azure SQL Database
Since the database copy can be considered as a full backup, we want to create also a file in order to place it on another place, that could be a local or a cloud storage.