Questions tagged [azure-sql-managed-instance]
258 questions
3
votes
0 answers
Cannot get Azure Managed Instance SQL server using GetByResourceGroup
I have c# code that exports azure db to blob storage. This code works with standalone sql server and elastic pool dbs but when I try this code with Managed Instance, I am not even getting SQL server details. Is this because of security settings of…
kalyan alapati
- 89
- 1
- 4
3
votes
2 answers
Rename a database on Azure SQL Managed Instance that is part of geo-replication
I have an Azure SQL Managed Instance that is set up with geo-replication. I have a database on this MI that I want to swap out with another database by renaming them:
ALTER DATABASE mydb MODIFY NAME = mydb_old;
ALTER DATABASE mydb_new MODIFY NAME…
Brad Crandell
- 850
- 1
- 8
- 22
3
votes
2 answers
Azure SQL Managed Instance Gen4 and Gen5 hardware choices
Azure SQL Database Managed Instance can be created on two different hardware generations Gen5 and Gen4 with the following differences:…
Jovan MSFT
- 13,232
- 4
- 40
- 55
3
votes
1 answer
Database creation/deletion times on Azure SQL DB Managed Instances take a long time
I have an Azure SQL Managed Instance and have noticed that database creation and deletion not only takes a long time, 3 minutes to create a new database and up to 5 minutes to then delete that database, but that those times can also fluctuate a lot…
Jon Cawte
- 33
- 3
2
votes
2 answers
Merge two XML columns in SQL Server
Hope, someone out there can help me with SQL Query, I am trying to merge two XML column, I am currently using SQL Azure 2019.
First XML
1
…
Declan Junior
- 83
- 7
2
votes
2 answers
Cannot open the properties tab in SSMS for Managed Instance Database
I am using Azure Managed Instance for some migration tasks. I have multiple databases in that all are working fine.
But when I try to open the properties for a database named GCDCalculation, I am getting the following error:-
And the whole error…
Robin
- 85
- 2
- 12
2
votes
1 answer
Unable to Export Data Tier in SQL Server When External Views Exists
I am planning on using SSMS, why I am unable to run Tasks->Export Data Tier Application on a database which has views pointing to another database tables. This is in Azure SQL MI.
Error Message
One or more unsupported elements were found in the…
Anand
- 1,845
- 2
- 20
- 25
2
votes
1 answer
Delete "orphaned" SSIS catalog
Not sure I am referring to this correctly, but we seem to have an "orphaned" or rogue Integrated Service Catalog, SSISDB, with a database SSISDB on an azure managed instance
We were testing SSIS options a few months ago including creating it in data…
Amommy
- 47
- 1
- 8
2
votes
1 answer
Azure Data Factory Managed Instance -> Snowflake text with escape characters
I've got a Copy Data Activity in Data Factory which takes a table from a SQL Server Managed Instance and puts it into a Snowflake Instance.
The activity uses a temporary staging BLOB account.
When debugging the pipeline it's failing.
The error comes…
Dan
- 111
- 10
2
votes
3 answers
Composite index on three columns
We have got 93M rows mapping table which is keeping mapping information of three tables and corresponding three tables. We are facing performance issues in accessing data from the mapping table.
TableName
PK information
Number of…
Venkataraman R
- 12,181
- 2
- 31
- 58
2
votes
1 answer
Error while creating External File Format in Azure SQL Database
Getting the error while creating External File Format in Azure SQL DB
Incorrect syntax near 'EXTERNAL'.
I am using the following commands (Used the T-SQL syntax from Microsoft Docs Link -…
Mayank Sharma
- 49
- 1
- 3
2
votes
1 answer
How can we add multiple subscriptions to one On-Premise Data Gateway?
We would like to connect our Azure Analysis Services to a Managed Instance.
There are 3 different subscriptions, Develop, Pre-Prod and Production
The public endpoints on the Managed Instances are turned off. So we are using an On-Premise Data…
Koen
- 475
- 4
- 17
2
votes
2 answers
Can i backup my service master key stored in azure managed instance?
I need to backup my service master key in managed instance and then restore it to secondary managed instance.
Priya Sharma
- 35
- 6
2
votes
1 answer
Available options to restore the db from Azure MI to local machine for confidential data
I have a requirement to backup the SQL database present in Azure Managed instance and restore it on local server for root cause analysis. This needs to be performed whenever we encounter a certain error on the DB. Since the automated backups are TDE…
PraveenDS
- 51
- 3
2
votes
0 answers
Setting Active Directory Admin for Azure SQL Managed Instance Fails
I am not able to add an active directory administrator to a newly created SQL Managed Instance in the Azure portal or with the Cloud Shell.
When I attempt in the Azure portal, the operation fails with the following message in the activity…
Cza102282
- 33
- 6