none
Restore database service-managed error RRS feed

  • Question

  • I have a database backup from sql server 2012 in Azure storage. If I restore backup to sql server installed on a Azure virtual machine it works OK but I restore backup to Azure database service-managed it works with error: "No backup selected to be restored".

    Please could you help me?

    Thanks in advance.


    Friday, November 15, 2019 6:59 AM

All replies

  • Please have a look at this how-to and let me know if it satisfies your needs: Restore a database to a Managed Instance

    Friday, November 15, 2019 7:58 AM
  • Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know.

    Sunday, November 17, 2019 1:45 PM
    Moderator
  • Thanks for your answer but it doesn´t work.

    If I execute the command  RESTORE FILELISTONLY FROM URL  (after create credentials), an Error occurs: "Operating system error 12002 (failed to retrieve text for this error. Reason: 317)."


    Friday, November 29, 2019 7:58 AM
  • Hi 

    Please convey the access level on your storage account from Firewall and Network tab under storage account. 

    Just for testing( if it is not already), Please select access from all networks and save it and then try to restore.

    Please check this and get back to us.

    Thanks
    Navtej S

    Monday, December 2, 2019 4:29 PM
    Moderator