SQL Server Managed instance, a deployment option of Azure SQL Database providing compatibility with the latest SQL Server on-premises Database Engine with PaaS features and capabilities.
Questions tagged [azure-sql-managed-instance]
57 questions
9
votes
3 answers
Restoring ANY database to Azure MI fails
Our freshly provisioned Azure SQL managed instance fails restoring backups from URL.
According to the server log the restore itself seems to finish after a certain amount of time but errors in following processes lead to a termination of the whole…
Andreas
- 173
- 1
- 7
6
votes
3 answers
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web application. The third is a read-only archive of the…
CB_Ron
- 239
- 3
- 9
5
votes
3 answers
SQL Managed Instance - Cross Subscription Restores/Migration
Short Version:
I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it to the point where I see the restore starting in…
Jonathan Fite
- 7,306
- 1
- 17
- 26
5
votes
2 answers
CLR Stored Procedure on Azure SQL Managed Instance error on execution: "Assembly in host store has a different signature than assembly in GAC"
I have a CLR stored procedure which executes correctly when deployed to local SQL Server instances from SQL Server 2012 - 2017. I can successfully deploy to an Azure SQL Managed Instance but when I execute the procedure I get the following…
JamesP
- 117
- 6
3
votes
0 answers
Azure SQL Managed Instance - Reboots - places to look?
We have been seeing what appears to be reboots on our SQL Managed Instances (Standard, Failover Group). One node (the current primary, USEast) has been apparently rebooting for the last 24 hours, between 30 minutes and 2 hours between cycles. This…
Jonathan Fite
- 7,306
- 1
- 17
- 26
3
votes
1 answer
Azure Elastic Pool - is it supported for MySQL?
I know that Elastic Pool in Azure is supported for SQL Server.
But I could not find any information if it is supported for MySQL.
I could not find any information in documentation at all what types of databases are supported...
Can you please assist…
Dejan
- 615
- 4
- 18
- 32
3
votes
0 answers
DNS CNAME for a SQL Managed Instance (Azure)
I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server.
I am looking to move this server to an Azure Managed Instance and I want to point the DNS CNAME at this server (the MI is in a VNet that is…
Lickrob
- 84
- 8
2
votes
0 answers
Linked server from Azure managed instance
I have my Managed Instance (MI) setup and can connect from SSMS on-premises. There is limited functionality this way (you only see databases and security) - so I have a VM in the v-net where I can manage the MI from.
I have set up a linked server…
jack
- 339
- 5
- 14
2
votes
1 answer
Azure Managed Instance - Is it possible to send Sql Logs To Log Analytics?
Is it possible to stream a Managed Instances SQL logs into log analytics?
I need a single location for all Azure based monitoring so that multiple teams have visibility/access to log information for issue investigation.
The idea being that if there…
dropStar
- 21
- 1
2
votes
3 answers
Restore DIfferential backup on azure managed instance?
I am migrating my database from on-premise to Azure managed instance. In order to move the database I'm using the organization weekly full backup, and I am asking them to take a diff after they take the application offline (the databases are very…
David
- 21
- 2
1
vote
0 answers
Data migration assistant showing breaking changes/ behaviour changes for SQL 2019 but not for Azure SQL Managed instance
I am trying to assess the potential issues while migrating a SQL Server 2012 on-prem database to Azure, with SQL on Azure VM and Azure SQL Managed instance as targets.
For SQL on Azure VM, DMA is showing few breaking changes and behavior changes…
UBK
- 111
- 1
1
vote
0 answers
Extended events error in Azure Managed instance
I have setup extended events on Managed instance. Below are the steps followed:
create a master key
Create a credential for Azure Blob storage with shared access token
Create the extended event and start the session
The session is running and I…
SQL_yogi
- 33
- 3
1
vote
1 answer
Configuring Azure SQL Server and SQL DB instance with MFA/2FA for On-premise AD DS synched account
I've synched my OnPremise AD DS users into Azure using Azure AD connect.
How can I enable the user of my Azure SQL Server and Azure SQL DB instance to use MFA/2FA when connecting with SSMS using the existing AD account?
Because at the moment,…
Senior Systems Engineer
- 135
- 1
- 1
- 7
1
vote
0 answers
Azure SQL DB and SQL MI Security Concerns
I have 7 different SQL Managed Instances, which were newly migrated over from SQL VM. I also have 7 different Azure SQL Databases, which were also newly created.
I want to make sure that I completely secure all my MI and Azure SQL Databases to…
MillionQueries
- 11
- 1
1
vote
2 answers
Maintenance Plan folder missing in SQL Managed Instance (via VM)
Accessing our new SQL Managed Instance via an Azure VM/SSMS, the Maintenance Plan folder is missing from the Object Explorer pane. Reading other posts (that all relate to other versions of SQL Server) I've checked I have the valid permissions:
Is…
EvilDr
- 778
- 1
- 10
- 23