backup to url

[williamsandrew144]

I faced with an issue to make a backup of a database to URL. Can you help me? Thanks in advance

 

[davismick643]

What version of SQL and Management Studio? 2012, 2014, 2016? SQL Server backup to URL feature is available since 2012. Give you just few recommendation to do this. 1. Unique file name for every backup is recommended to prevent accidentally overwriting the blobs. 2.When creating a container, it is recommended that you set the access level to private, so only users or accounts that can provide the required authentication information can read or write the blobs in the container. 3.For SQL Server databases on an instance of SQL Server running in a Windows Azure Virtual Machine, use a storage account in the same region as the virtual machine to avoid data transfer costs between regions. Using the same region also ensures optimal performance for backup and restore operations. 4.Failed backup activity can result in an invalid backup file. We recommend periodic identification of failed backups and deleting the blob files. 5.Using the WITH COMPRESSION option during backup can minimize your storage costs and storage transaction costs. It can also decrease the time taken to complete the backup process. More information you can find here [URL unfurl="true"]https://technet.microsoft.com/en-us/library/dn435916.aspx[/url] [URL unfurl="true"]http://sqlbak.com/blog/sql-server-backup-to-url/[/url] [URL unfurl="true"]https://technet.microsoft.com/en-us/library/jj919149[/url]

 

[philhege]

What are these "storage costs" of which they speak?

Oh, the cloud; never mind.

-----------
With business clients like mine, you'd be better off herding cats.