Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
0
votes
1 answer

is tempDB included in the storage limit of managed instance?

I'm trying to ascertain the log space limits, It seems that storage limit includes log space from the documentation. what about system databases - specifically tempdb included in the managed instance storage limit ?
Tulsi Patel
  • 9
  • 1
0
votes
1 answer

Why Azure SQL Managed Instance needs IP address 168.63.129.16 in custom DNS configured in instance subnet and how it affects name resolution

I want to setup custom DNS for Azure SQL Managed Instance and according to the documentation I need to put Azure Recursive Resolver DNS IP address 168.63.129.16 at the end of the virtual network DNS list. Would adding 168.63.129.16 to DNS list…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

Why Azure SQL Managed Instance requires UDR 0.0.0.0/0 next hop type Internet

One of the networking requirements for the Azure SQL Managed Instance is to have UDR 0.0.0.0/Next hop internet that enables access from the private subnet that belongs to Azure VNet and public internet. Why is this required and what are the risks?
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

How to validate and configure existing VNet/subnet for Azure SQL Managed Instance

Azure SQL database - Managed Instance must be placed in Azure VNet in dedicated subnet within the VNet. There are some special requirements that VNet and subnet must satisfy that are described here:…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

How to create Azure VM that could be used to connect to Azure SQL Managed Instance using SSMS?

I have an Azure SQL Managed Instance that is placed in VNet and I need to create an Azure VM with SSMS to connect to the Managed Instance. What is the easiest way to configure it?
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

How to connect to Azure Sql Managed Instance in VNet from my laptop using point to site connection (P2S)?

Azure SQL Managed Instance is placed in private Azure VNet with private IP address. How can I connect to the instance directly from my local machine/laptop? How to connect my machine to the VNet where the instance is placed using point-to-site…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

What to do if Azure SQL Managed Instance reaches the max storage limit?

Azure SQL Managed Instance can reach the storage limit if the total sum of sizes of the database (both user and system) reaches the instance limit. In this case the following issues might happen: Any operation that updates data or rebuild…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
1 answer

Azure SQL Timeout after query inactivity

I'm experiencing frequent timeouts on my managed Azure SQL Instance. When no query activity have occurred for some time, the first query, which is expected to return between 500-2000 rows, will use all the available DTUs in my pricing tier (S2 50…
Mortenkp25
  • 171
  • 1
  • 3
  • 14
0
votes
1 answer

TDE on Azure SQL Managed Instance

TDE is not enabled on MI by default. I had manually enabled TDE by setting the encryption to true in the db properties. Encryption of the DB took around 20 mins and below is the output from the sys.dm_database_encryption_keys table. How do we…
sunil cherukuri
  • 1
  • 2
0
votes
3 answers

Increase Azure SQL Managed Instance backup retention beyond 7 days

Azure SQL Managed Instance provides a default backup retention of 7 days and this cannot be changed as per MS. Access to the Automated backups are not provided as well which is quite surprising. My client requires the backups to be restored for…
Bhanu
  • 1
  • 2
0
votes
1 answer

Connection problem Azure Managed Instance and Data Factory with Windows authentication

I have a Azure SQL Managed Instance and a Azure Data Factory V2. Now I want to get a connection with Windows Authentication between a SQL database and ADF V2.I added a Active Directory User with the "CREATE USER ... FROM EXTERNAL PROVIDER"…
Markus Stögerer
  • 21
  • 3
0
votes
1 answer

Unable to create client VM that access Azure Sql Managed Instance due to core quota limit

I have create Azure SQL Managed Instance and I want to create client VM that will be used to access the instance. I have copied the configuration script from the Azure portal: When I execute this script via PowerShell, I'm getting the following…
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
0
votes
3 answers

Azure DevOps Deployment to Azure SQL Managed Database

Is there a way to deploy SQL Database project to Azure SQL Managed Database from Azure DevOps ? Are there ports to open on Azure Network Security Group ? Thank you Bertrand
Bertrand Pons
  • 257
  • 2
  • 18
0
votes
1 answer

Dynamics Data Export Service to Azure SQL Managed Instance

I understand that we can set up Dynamics data export service to Azure SQL database however can we do that for Azure SQL Managed Instance instead?
SHB
  • 87
  • 2
  • 8
0
votes
1 answer

ALTER DATABASE ADD FILE fails due to running backup in azure sql Managed instance

We are running a monthly script for partition update. in the script we also run ALTER DATABASE ADD FILE and ALTER DATABASE REMOVE FILE. The script should be for running for about 20 minutes. when running the script we are getting an error: Backup,…
Idit Hecht
  • 1
  • 1
1 2 3
…
17 18