Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

backup to url

Status
Not open for further replies.

williamsandrew144

Programmer
Jul 23, 2015
3
UA
I faced with an issue to make a backup of a database to URL. Can you help me? Thanks in advance
 
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]
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top