Limitations of Azure Arc-enabled SQL Managed Instance
This article describes limitations of Azure Arc-enabled SQL Managed Instance.
Back up and restore
- User databases with SIMPLE recovery model are not backed up.
- System database
modelis not backed up in order to prevent interference with creation/deletion of database. The database gets locked when admin operations are performed.
Point-in-time restore (PITR)
- Doesn't support restore from one Azure Arc-enabled SQL Managed Instance to another Azure Arc-enabled SQL Managed Instance. The database can only be restored to the same Arc-enabled SQL Managed Instance where the backups were created.
- Renaming databases is currently not supported, during point in time restore.
- No support for restoring a TDE enabled database currently.
- A deleted database cannot be restored currently.
- Transactional replication is currently not supported.
- Log shipping is currently blocked.
- All user databases need to be in a full recovery model because they participate in an always-on-availability group
Roles and responsibilities
The roles and responsibilities between Microsoft and its customers differ between Azure PaaS services (Platform As A Service) and Azure hybrid (like Azure Arc-enabled SQL Managed Instance).
Frequently asked questions
This table summarizes answers to frequently asked questions regarding support roles and responsibilities.
|Question||Azure Platform As A Service (PaaS)||Azure Arc hybrid services|
|Who provides the infrastructure?||Microsoft||Customer|
|Who provides the software?*||Microsoft||Microsoft|
|Who does the operations?||Microsoft||Customer|
|Does Microsoft provide SLAs?||Yes||No|
|Who’s in charge of SLAs?||Microsoft||Customer|
* Azure services
Why doesn't Microsoft provide SLAs on Azure Arc hybrid services? Customers and their partners own and operate the infrastructure that Azure Arc hybrid services run on so Microsoft can't provide the SLA.
Try it out. Get started quickly with Azure Arc Jumpstart on Azure Kubernetes Service (AKS), AWS Elastic Kubernetes Service (EKS), Google Cloud Kubernetes Engine (GKE) or in an Azure VM.
Create your own. Follow these steps to create on your own Kubernetes cluster: