search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

Do this page also valid for azure managed instances? #32749

Closed Anmolgan81 closed 5 years ago

Anmolgan81 commented 5 years ago

The topic that talks about differential, full, and transnational backups taking place also valid for azure managed instance?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Mike-Ubezzi-MSFT commented 5 years ago

@Anmolgan81 That document refers to the PaaS service - Azure SQL Database (Singleton or Single Instance). It does not refer to Managed Instance. Please see the navigation on the let to see the difference between the two.

alt text

Anmolgan81 commented 5 years ago

Can you provide me a link so that I can visit the link??

Mike-Ubezzi-MSFT commented 5 years ago

@Anmolgan81 I am being corrected and wanted to follow-up with you with the following. The documentation will be corrected as part of a larger work item but the following needs to be stated here:

All PaaS, Security, Database features articles apply to all tiers and flavors unless if it is not stated differently on the page

This GitHub issue has highlighted an issue with how the documentation is structured given the complexity of understanding the three (now 4 with hyperscale) deployment options. This will be corrected. Thank you!

Ayanmullick commented 5 years ago

The 'Manage Backups' blade isn't available for Managed instance as it is for AzSQLdb. Are there separate PowerShell cmdlets to setup Managed instance backups specifically?

Anmolgan81 commented 5 years ago

We need the functionality to take manual backups, so that we can work on dev environment of azure sql database and can restore the databases there.

Mike-Ubezzi-MSFT commented 5 years ago

Here is a PowerShell example to restore a backup file for Managed Instance (link).

Anmolgan81 commented 5 years ago

Hi @Mike-Ubezzi-MSFT I am looking for taking backups of a managed instance and then storing it inside the azure storage account and then do a restore to azure sql database. Is that something possible? what are the steps in order to achieve this?

Mike-Ubezzi-MSFT commented 5 years ago

The Managed Instance (link) PowerShell examples does not have an example to initiate an on-demand backup file. My previous comment will allow you to restore a backup file on demand.

Anmolgan81 commented 5 years ago

Hi Mike,

Is that something which is not supported by Managed Instance??

If that is it then how can we transfer backups from on-production Managed Instance to Dev/Test Environment enabled Managed Instance?

Regards Anmol Ganju

Mike-Ubezzi-MSFT commented 5 years ago

@Anmolgan81 I do not think it is supported because of the reasons stated in the following response to this Uservoice post.

Anmolgan81 commented 5 years ago

Hi Mike,

The documentation does not say that taking backups of azure managed instance is not supported. It says that restoring to azure sql database is somehow not supported.

Regards Anmol Ganju

Mike-Ubezzi-MSFT commented 5 years ago

@Anmolgan81 The functionality you are seeking is not supported. I was attempting to provide support for this decision in that the backup (specifically .bak) files are locked down (short-term and long-term retentions policies) to prevent movement of these files. Can you make a product request to at least be able to generate a .bacpac file on-demand (link). Thank you.

Mike-Ubezzi-MSFT commented 5 years ago

We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.