How to do Log Shipping B/w 2008 SQL Server and Azure Managed Instance?

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure

https://docs.microsoft.com/azure

Creative Commons Attribution 4.0 International

10.12k stars 21.19k forks source link

How to do Log Shipping B/w 2008 SQL Server and Azure Managed Instance? #23767

Closed Anmolgan81 closed 5 years ago

Anmolgan81 commented 5 years ago

How to do Log Shipping B/w 2008 SQL Server and Azure Managed Instance?

Document Details

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

ID: 3fb7dad4-ff47-5b16-e8ee-0a5e037ea20f
Version Independent ID: 98ec245b-bd8f-bd96-ec6d-0048599246fa
Content: Azure SQL Database feature comparison
Content Source: articles/sql-database/sql-database-features.md
Service: sql-database
GitHub Login: @jovanpop-msft
Microsoft Alias: jovanpop

angoyal-msft commented 5 years ago

@Anmolgan81 Thanks for your concern. We are actively investigating this issue and will be get back to you soon.

Mike-Ubezzi-MSFT commented 5 years ago

@Anmolgan81 Log Shipping is an automatic feature when you subscribe to an Azure SQL Database (PaaS) offering but does not apply to an on-premise to Azure scenario. It is purely an only Azure functionality. Given the other issues created (#23809, #23778, #23779), you are now in the process of configuring replication between an on-premise instance and an Azure SQL Database Manage Instance, which is how log shipping is achieved. We will now proceed to close this issue but if you should have any additional questions we are happy to continue this discussion.

danimir commented 3 years ago

@Anmolgan81 - We have now enabled customers to use log-shipping as a part of the external service LRS (Log Replay Service) for SQL Managed Instance. More information here: https://aka.ms/mi-logreplay-service. Hope this helps.