question

andersonjos87 avatar image
andersonjos87 asked

Backup to URL

I am faced with an issue where I need to make a backup of a database to a URL. Can you help me? I'm on Sql Server 2012. Thanks in advance.
sqlbackup
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Are you using 2014/2016 or do you mean UNC/Network?
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
You have several answers below. For each of those answers that are helpful you should click on the thumbs up next to the answers so that it turns green. If any one of the answers below lead to a solution to your problem, click on the check mark next to that one answer so that it turns green. This web site works best if you do the voting and marking of answers so that the next person who looks at your question knows what the solution was.
0 Likes 0 ·
danlout144 avatar image
danlout144 answered
What version of SQL? 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 here [ https://technet.microsoft.com/en-us/library/dn435916.aspx][1] [ http://sqlbak.com/blog/sql-server-backup-to-url/][2] [ https://technet.microsoft.com/en-us/library/jj919149][3] [1]: https://technet.microsoft.com/en-us/library/dn435916.aspx [2]: http://sqlbak.com/blog/sql-server-backup-to-url/ [3]: https://technet.microsoft.com/en-us/library/jj919149
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

danlout144 avatar image
danlout144 answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.