Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
0 answers
Using tiny_tds gem unable to connect to Azure Managed instance sql server
I'm in a linux container using the gem file tiny_tds (verions 2.1.1) to try to connect to sql server on an Azure Managed instance.
The code I'm using to connect is this:
client=TinyTds::Client.new(:username=>'username@full.server.name', :password=>…
ferris
- 55
- 9
0
votes
1 answer
Need Support to finalize the Migration method to migrate a Azure SQL MI Databases from Azure Cloud-Company Account to Azure Cloud-Clients Accounts
We are trying to Migrate Azure SQL Managed Instance Databases from Azure Cloud - Company Account to Another Cloud in Clients Accounts. Need help to choose the right migration methods to migration the Azure SQL MI Databases across subscription and…
0
votes
1 answer
what is the best way to copy a large sql database from azure managed instance to azure single database?
Hello folks first post in stack, btw wonderful community and helps out a lot.
like mentioned in the title what is the best way to copy such a large database? we got an ~ 500 GB Database and im currently moving this database from managed instance to…
0
votes
1 answer
Decryption issue with Azure SQL Managed Instance CLE on secondary instance of a failover group
We have an Azure SQL Managed Instance Failover Group setup with a primary and secondary instance – the issue I’m hitting is that we use cell (column) level encryption (CLE) for some of our database table columns. My limited understanding is that…
Robert Shattock
- 135
- 1
- 8
0
votes
0 answers
Need to create Azure SQL Managed Instance from existing VNET and SUBENT using ARM
I need to create SQL Server Managed instance from existing VNET/SUBNET in ARM
But I tried multiple ways but its didnt help and getting failed again and again
So kindly help me to create script
0
votes
1 answer
Alternative to xp_cmdshell in Azure SQL Managed Instance to rename files?
One of my developers was asking me to enable xp_cmdshell in our on-premises SQL server so she could test renaming files from SQL Server stored procedure. Since xp_cmdshell is not supported in Azure SQL Managed Instance (and it looks like a security…
Pablo
- 5
- 3
0
votes
0 answers
Large table performance in SQL server
For one of our application, we have really large volume SQL table which has 100 million rows and we are using Azure SQL managed instance. On daily basis users will either insert new records or updates very old records. This is the core table where…
Venkat
- 1
- 2
0
votes
2 answers
Why can't I restore a SQL Backup on a newer Version? Error 3169
I am trying to restore a backup from an Azure Managed Instance to an SQL Server running on an Azure VM.
When running the Backup Script, I get this error Message:
Meldung 3169, Ebene 16, Status 1, Zeile 2
The database was backed up on a server…
Jay
- 3
- 3
0
votes
1 answer
How to schedule daily backup of azure sql managed instance databases to an azure blob
I have a Azure storage account and a blob container. I have 6 databases on my azure sql managed instance. I want to schedule automated daily backup of all the databases to the blob according to a specified CRON expression. How to achieve this.…
Rahul Dev
- 141
- 2
- 17
0
votes
1 answer
Multiple composite index vs single non-clustered column store index
We have a OLTP system and we have got a grid, which is containing close to 20 columns, coming from multiple tables. The grid loaded based on search parameters involving around 6 columns. The data is huge with 100M rows coming from background…
Venkataraman R
- 12,181
- 2
- 31
- 58
0
votes
1 answer
Getting error in alter statements in azure sql managed instance
Hi i have a azure sql managed instance and when i execute the below query i get the error as
The operation cannot be performed on database "" because it is involved in a database mirroring session or an availability group. Some operations are not…
ashish
- 273
- 1
- 5
- 16
0
votes
1 answer
Azure Manage Instance Student Cost
I am preparing for certifications and can't afford the $700+ cost for a low tier Azure managed instance. I do have pay as you go and student subscriptions but the cost is unaffordable. Is there a workaround for the pricing?
0
votes
1 answer
verification of SQL Managed Instance migration
is there a way to verify that a SQL Server to an Azure SQL Managed Instance migration was successful? More detailed question would be, how can I check that there is no data corruption? Is there is not, it is because CHECKSUM in Backups is…
Carles G
- 15
- 4
0
votes
1 answer
Power BI Data Refresh from Azure Managed Instance
I have an Azure Managed Instance and a database that I am able to connect from SSMS and Power BI Desktop, port 3342, but I am not able to schedule a refresh from within the Power BI Service or MS Flow. My guess is that there Azure to Power BI…
nabullock
- 1
- 1
0
votes
0 answers
How to optimize Azure Data FactoryPipeline?
Need help on the below requirement...
I have to perform ADF migration from 90(source and target Azure MI databases)
For Example Source on-prem servers(data server1, data server2, data server3,...data server90) to
Target Azure MI Servers(Azure MI…
Hemant Sudehely
- 49
- 1
- 10