SQL 2014 Cloud Backups Part 5

With the credentials saved we are now ready to take a backup of the database. Below screenshot shows how to backup using the GUI or the script .

Via Script

BACKUP DATABASE [madworks]
TO URL = N'https://ebsclouddbstore.blob.core.windows.net/mssqlbackups/madworks_backup_2015_01_08_211215.bak'
WITH CREDENTIAL = N'Azureblobbackups' , NOFORMAT, NOINIT,
NAME = N'madworks-Full Database Backup', NOSKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

 

And that is all there is to taking backups in the next part we perform a restore.