Contents tagged with backup

  • There is currently a lease on the blob and no lease ID was specified in the request

    Tags: Azure, backup, SQL 2012

    I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well, but a couple of times I have had an issue where I wasn’t able to overwrite a previous backup file and received an error:

    Msg 3202, Level 16, State 1, Line 1Write on https://somestorage.blob.core.windows.net/somecontainer/MyDb.bak failed: Backup to URL received an exception from the remote endpoint. Exception Message: The remote server returned an error: (412) There is … more

  • Backup SQL database directly to Azure Storage

    Tags: Azure, backup, DR, SQL 2012, CU

    There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in the documentation blogged here.

    This is one of two new improvements and it is described as:

    You can now directly create a backup to Windows Azure Storage using SQL Server Native Backup functionality. This will allow users to back up a SQL Server database on an on-premises instance or on an instance of SQL Server that is running in a hosted environment, such as the Windows Azure Virtual Machine. … more