Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [azure-sql-managed-instance]

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.

134 questions
10
votes
3 answers

How do I drop a database which has brackets in its name?

I have a database which has brackets in its name. (Don't ask! :-\ ) It shows in SSMS but not in Azure because it was canceled while creating. It does not show in the database listing in Azure. It shows in SSMS but it cannot be deleted by…
Yossi Geretz
  • 349
  • 1
  • 11
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
7
votes
3 answers

Azure SQL Managed Instance: 1. excessive initial compile times leading to app timeouts and 2. partition maintenance: long-running, bloats data file

We are having a couple of issues preventing us from going live with an on-prem SQL 2016 Std Ed to Azure SQL Managed Instance Business Critical tier re-platform, and I was wondering if anyone had similar issues and had advice for us. Our issues…
Mike Petrak
  • 436
  • 6
  • 16
6
votes
4 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
  • 9,414
  • 1
  • 25
  • 30
6
votes
4 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
  • 291
  • 1
  • 4
  • 11
5
votes
2 answers

How can I delete extended event files from within Managed Instance?

Simplifying a few details, I have a recurring process on SQL Server 2019 which runs every 10 minutes and does the following: Reads data from extended event file targets using sys.fn_xe_file_target_read_file Processes the data and saves it to a…
Joe Obbish
  • 32,976
  • 4
  • 74
  • 153
5
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
  • 9,414
  • 1
  • 25
  • 30
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…
Jim P
  • 127
  • 1
  • 7
3
votes
1 answer

sp_blitzlock returns blank data in SQL Managed instance

I have a SQL Managed Instance in Azure with some blocking/deadlocking going on. This DB was on-premise and had all the scripts installed, so I uninstalled them and then installed the Azure specific scripts (Install-Azure.sql), downloaded fresh from…
Aaron Giambattista
  • 33
  • 2
3
votes
2 answers

I'm having trouble copying database users from one Azure SQL Server to another. The EXECUTE permission was denied

I'm trying to use the instructions here - https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/security/transfer-logins-passwords-between-instances to copy logins between the server which hosts my primary DB and the server which hosts…
Yossi Geretz
  • 349
  • 1
  • 11
3
votes
2 answers

How do I resolve this python runtime error in Azure SQL Managed Instances?

We recently setup a new managed instance through the program that allows you to try it for free. When trying to run the following code from Microsoft's documentation: EXECUTE sp_execute_external_script @language =N'Python', @script=N'import sys;…
Joe Obbish
  • 32,976
  • 4
  • 74
  • 153
3
votes
2 answers

How to gather Index usage information

Following query correctly outputs number of seeks, scans, etc. I have question on understanding some rows in the output. In some output rows of the query, the index name is shown as NULL and the index_type is shown as HEAP, and NumOfSeeks as 0;…
nam
  • 515
  • 5
  • 15
3
votes
2 answers

Unable to open database properties window in SSMS

I am using Azure SQL MI. Using SSMS, I backed up an SQL db to an Azure container. After that I am unable to open the Properties windows of that database using SSMS. When I right click on the database and click on Properties menu, I get the following…
nam
  • 515
  • 5
  • 15
3
votes
1 answer

SQL Server Data Tools -- Stopped connecting to Azure SQL DB

All updates are installed on VS 2017 (15.9.47) and 2019 (16.11.13) I am trying to perform a data comparison between two DB's via Microsoft’s tool , On Prem and Azure SQL managed instance Everything has been working fine for the last few months I…
TSide
  • 31
  • 2
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
  • 695
  • 7
  • 20
  • 34
1
2 3
…
8 9