locked
Blob Sql 2016 Backup RRS feed

  • Question

  • I can not make backups of my databases using maintenance plan to the html target in azure. When you try to create a credential the storage account is not listed. Can you help me ?

    Monday, June 18, 2018 6:12 PM

All replies

  • Just to clarify, are you following any documentation for step-by-step process?

    Could you explain a bit more on your query ?


    • Edited by vikranth s Monday, June 18, 2018 6:50 PM
    Monday, June 18, 2018 6:47 PM
  • For SQL databases in Azure: 

    "Starting with SQL Server 2012 SP1 CU2, you can now write SQL Server backups directly to the Azure Blob storage service. You can use this functionality to back up to and restore from the Azure Blob service with an on-premises SQL Server database or a SQL Server database in an Azure virtual machine. Backup to cloud offers benefits of availability, limitless geo-replicated off-site storage, and ease of migration of data to and from the cloud. You can issue BACKUP or RESTORE statements by using Transact-SQL or SMO."

    Source: 
    https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-use-storage-sql-server-backup-restore

    Turotials: https://docs.microsoft.com/en-us/sql/relational-databases/tutorial-use-azure-blob-storage-service-with-sql-server-2016?view=sql-server-2017
    Tuesday, June 19, 2018 10:48 PM
  • Checking in to see if the above response helped to answer your query. Let us know if there are still any additional issues we can help with.


    Thursday, June 21, 2018 7:32 PM