Enhanced management capabilities to release unused subnets and create databases available for Azure SQL Database Managed Instance
Published date: 24 June, 2019
Azure SQL Database Managed Instance introduces new options, further enhancing its management and automation capabilities. New management options include capability for immediate release of subnet upon deletion of the last Managed Instance residing in it using Azure portal and API, and new options to create instance databases using Azure portal, PowerShell and API.
Upon deletion of the last Managed Instance in the same subnet, the virtual cluster that has contained instances is kept for customers free of charge for the next 12 hours to allow for faster creation of new Managed Instances in the same subnet. In case customers do not plan to provision new Managed Instances in the same subnet and they would like to immediately release the subnet for further use, this is now possible through manual deletion of the virtual cluster. Deletion of an empty virtual cluster is available through Azure Portal and programmatically through API, resulting in an immediate release of the used subnet.
New options for creating instance databases through Azure portal, PowerShell and API along with the existing T-SQL capabilities are now available for Managed Instance. These options complete the create database experience for Managed Instance, providing customers with the ability to programmatically automate creation of instance databases and enable easier usability of these feature through Azure portal.
To learn how to delete virtual cluster and release used subnet, see Delete subnet after deleting Azure SQL Database Managed Instance. To learn how to create instance databases using PowerShell, see Create instance database using PowerShell library, and through using API, see Managed Databases - Create or Update method.