I'm trying to do a backup from SQL Server 2012 to Azure (free account), but I'm getting this error:

'URL' is not a recognized Device Type option

I´m writing the instruction like this:

TO URL = N'https://myaccount.blob.core.windows.net/myContainer/MyDatabase.bak'

The size of the DB is small (less than 2 GB), I'm just trying out the Azure services.

The SQL Server 2012 does not recognize the word URL, I looked up for a solution on the web and I founded I was needing the SP1 Compact 2 or later versions to install, so I installed the mos recently version of SP1 Compact 4 and.. did not work.

Do you have any suggestions to solve my problem?

Thank you so much in advance!

  • Can you run SELECT @@VERSION and post that up?
    – HandyD
    May 7 '20 at 22:53
  • Thanks a lot, I worked by installing the SP4
    – Pamela
    May 8 '20 at 19:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.