Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
1
vote
1 answer

Deleted Database Still Shows in Object Explorer

In Azure managed instance: I have deleted database from SSMS using GUI and it showed success message as well. The deleted database does not show under Azure Portal as well When reconnecting to the managed instance using SSMS, the database name shows…
Kapil J
  • 11
  • 1
1
vote
3 answers

Restore a large SQL Managed Instance to On Premise

We are trying to restore a large SQL Managed Instance database to On Premise running SQL Server 2016. We tried SQL Export Dump, since the database is large it is taking a long time to complete. Are there alternative approaches to copy SQL Managed…
Kumar
  • 11
  • 1
1
vote
1 answer

Azure SQL Managed Instance Routing Tables

I have created a new instance of an Azure SQL Management instance which also create a default routing table as described within this document. What our client is trying to achieved is to route all traffic through a CheckPoint firewall so that it can…
Phil Murray
  • 6,396
  • 9
  • 45
  • 95
1
vote
2 answers

Azure SQL Slow Query when targeting an index

I've a relatively large DB used for IoT data, approximately around 60 million records. Inserts are performed very frequently in BULK Inserts from Stream Analytics. This is my table schema: CREATE TABLE…
Mortenkp25
  • 171
  • 1
  • 3
  • 14
1
vote
1 answer

How to create Azure SQL Managed Instance using AzureRm.Sql PowerShell library?

I need to automate creation of Azure SQL Database Managed Instance using PowerShell scripts (AzureRm.Sql). What command should be used to create it?
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
1
vote
1 answer

Is Possible to connect Azure SQL managed Instance from Azure SQL DB?

Is Possible to connect Azure SQL managed Instance from Azure SQL DB? By design, Azure SQL database is PaaS model with public end point only and Managed Instance has got only private end point. So how to connect the both? We need to access (Read) few…
Vs83
  • 21
  • 3
1
vote
1 answer

How to reset sql admin password on Azure SQL Managed Instance?

How to reset the sql admin password on Azure SQL Managed Instance if there is only one user/admin and the admin password is lost/forgotten? Could it be done via portal or using some script?
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
1
vote
1 answer

View Server State and View All Definitions in SQL Managed Instance

New to SQL Managed Instances. Currently I am testing our on-prem SQL databases in an Azure Managed Instance. There are some logging procedures in our application database which are gathering information to save in an audit trail. Some of these are…
C Gall
  • 11
  • 1
1
vote
1 answer

Azure Managed instance can't create or restore DB

Edit: I am using SSMS 17.9 I created an Azure Managed Instance and am having a few issues with it. I am able to connect to it through SSMS but when I navigate and try to expand the Databases folder I get this error: So I tried to create a DB on it…
Matt
  • 500
  • 7
  • 18
1
vote
1 answer

Azure SQL Management instance - restore db different version

Actually we have Azure SQL Management instance I got a backup but I cannot restore our VM SQL Server owing this has a SQL Server version less SQL Azure (Azure Team updated SQL Server a couples week ago), so We cannot update QA Server to last SQL…
Carlos Bolivar
  • 307
  • 5
  • 12
0
votes
0 answers

What does Azure SQL MI space used Metrics value represents?

What is this metrics value means in Azure SQL MI ? Does this value includes used space by the data or total space used including log files and other files? I Am trying to understand this metric value.
Faisal Kayani
  • 1
  • 2
0
votes
0 answers

Azure SQL MI Storage space used Metrics

What is this metrics value means in Azure SQL MI represents as it value is different from actual storage space used
Tahami Rizwan
  • 41
  • 4
0
votes
1 answer

Azure SQL MI storage space alert

I want to create an alert on azure SQL MI if storage space is used more than 80%.But not found any condition on storage space used percentage. Image is attched that shows available options to set alert How can I set an alert on Azure SQLMI on…
Tahami Rizwan
  • 41
  • 4
0
votes
1 answer

About Azure SQL Managed Instance specifications

I'm trying to incorporate the use of Azure SQL Managed Instance in my organization, being one the reason the data virtualization capability that Azure SQL doesn't have. I was trying the pricing calculator and got confused about two items in its…
jona
  • 23
  • 4
0
votes
1 answer

PowerShell to check available free space in Azure SQL Managed Instance

I am working on a PowerShell script to restore databases dynamically from the Azure storage account to Managed instance. To add additional functionality I am looking for a PowerShell module that can help me to find free space from managed instances…
Vinod Narwal
  • 169
  • 2
1 2 3
…
17 18