Azure SQL Database managed instance
A managed instance in Azure SQL Database is a fully managed SQL Server Database Engine Instance hosted in Azure cloud. This is the best PaaS option for migrating your SQL Server database to the cloud. Learn how to create and use Managed Instance with our quickstarts, tutorials, and samples.
Find out more information about managed instance in Azure SQL Database.
Rich surface area
Near 100% SQL feature compatibility with the latest version of SQL Server Database Engine.
Secure service placed in your private Azure VNet with private IP addresses.
Easily migrate your on-prem databases to Azure cloud using native restore.
Migration without downtime
Migrate a fleet of databases with minimal downtime using Database Migration Service.
Save up to 40% with Azure Hybrid Benefit (AHB) with your existing on-premises licenses.
Azure PaaS enables you to use 99.99% available instance with minimal management.
Choose between General Purpose and Business Critical service tiers depending on your business needs.
Secure your instance and databases with built-in Azure SQL database security features.
New and preview features
We are continuously improving managed instance with new features:
- (Preview) Instance pools - provide a convenient and cost-efficient way to migrate smaller SQL instances to the cloud.
- 4 vCores on Gen5 hardware generation
- Support for subscriptions with Azure monthly credit for Visual Studio subscribers
- Support for SharePoint 2016 and SharePoint 2019 and Dynamics 365 Business Central
- Configure time zone during instance creation.
- Create instances with server-level collation of your choice.
- Geo-restore functionality enables you to restore your database to another data center using PowerShell.
- (Preview) Re-create dropped databases using PowerShell
- Managed instances are protected with built-in firewall.
- (Preview) Bring your own encryption keys while migrating on-premises databases that already have enabled Transparent Data Encryption (TDE).
- (Preview) Use Geo-distributed failover groups to keep a copy of the instance in the another region and ensure that your data will be available even in the regional disaster scenario.
- Configure backup retention up to 35 days for Point-in-time restore. Note that Long-term backup retention (up to 10 years) is still not enabled so you can use Copy-only backups as an alternative.
- (Preview) Create Instance-level Azure AD server principals (logins) using CREATE LOGIN FROM EXTERNAL PROVIDER .
Managed instance enables you to easily perform basic management tasks using the Azure portal, Azure CLI, and Azure PowerShell. Learn how to perform basic management tasks using the following quickstart samples:
Step-by-Step tutorials and learning materials
Learn how to create, manage, and use managed instances.
- Learn how to quickly get started with managed instance using our quickstart guides.
- Learn about hardware characteristics and limitations, Transact-SQL language differences, and Transact-SQL, PowerShell, Azure CLI API for configuring managed instance.
- Configure Azure VNet where the managed instance will be deployed.
- Validate that your existing Azure VNet can be used to deploy managed instances.
- Connect to your instance using Public IP endpoint, Azure Virtual Machine or Point-to-site connection, or Applications.
- Verify that your database can be migrated using Data Migration Assistant or Database Experimentation Assistant.
- Bring your databases to managed instance using Native restore or Data Migration Service.
- Move your SSIS packages to Azure Data Factory, SSAS tabular models to Azure Analysis Service, and SSRS reports to PowerBI Premium.
- Learn about the storage layer in General Purpose tier and apply storage performance best practices and considerations for General Purpose service tier.
- Find the best practices and recommendations for securing your instance.
- Find more How-to guides that can help you configure your managed instance.