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.

Please Consider Subscribing

Subscribe