Managed backup configuration not succeeding RRS feed

  • Question

  • Hi,

    When trying to set up managed backup to Azure, I get error. I've went through different blogs and Technet articles discussing this, but non seem to work. I'm using SQL 2016 RTM (but same occurred on preview versions as well).

    First I create SAS using CloudXplorer, and it looks something like this:


    That URL in itself doesn't work when testing with browser, but appending few querystrings (&comp=list&restype=container) and it works fine and displays blob container contents just fine. 

    Then I create credential like:

    CREATE CREDENTIAL [https://XXXXX.blob.core.windows.net/sql] 

    And finally try to configure the managed backup using command:

    Use msdb;
    EXEC msdb.managed_backup.sp_backup_config_basic   
    @enable_backup = 1,   
    @database_name = NULL,  
    @container_url = 'https://XXXXX.blob.core.windows.net/sql',
    @retention_days = 14  

    but it throws error:

    Msg 45207, Level 17, State 6, Procedure sp_add_task_command, Line 102 [Batch Start Line 11]
    SQL Server Managed Backup to Microsoft Azure cannot configure the default backup settings for the SQLServer instance because the container URL was invalid. It is also possible that your SAS credential is invalid.

    I've tried several different combinations and changing the @container_url and the credential URL, but I always get this error.

    Any tips?

    • Edited by Jussi Palo Tuesday, June 14, 2016 1:39 PM
    Tuesday, June 14, 2016 1:38 PM

All replies