Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
0
votes
2 answers

Azure - never ending Full Backup Uploading in Database Migration Service

I have been migrating some databases from a SQL Server to an SQL Managed Instance. 13 of 14 DBs have been successfully restored. There is only one remaining, the biggest one with almost 600 Gb. It has been more than a week continuously uploading the…
Carles G
  • 15
  • 4
0
votes
2 answers

Trying to create a VM to acess a SQL Azure Managed Instance - (The selected subnet is not supported)

I have created an Azure SQL Managed Instance but I am unable to create a VM to connect to it as I need to put it on the same Subnet. When I try to do so I am not given the option. I can select the virtual network that was created with my Managed…
Keith Jackson
  • 3,078
  • 4
  • 38
  • 66
0
votes
2 answers

How to run sql profiler on read only node of SQL Manage instance in Azure?

We are using readonly node of SQL MI azure using applicationIntent=Readonly property in connection string. When we enable sql profiler on readonly node then it connect only read-write node only . Can anyone suggest how can we enable profiler or…
NP007
  • 659
  • 8
  • 21
0
votes
1 answer

Azure Data Factory - Azure SQL Managed Services incorrect Output column type

I have decided to try and use Azure Data Factory to replicate data from one SQL Managed Instance Database to another with some trimming of the data in the process. I have set up two Datasets to each Database / Table imported the schema ok (these…
CKelly-Cook
  • 195
  • 3
  • 10
0
votes
1 answer

Is it possible to copy a azure managed sql service database into an on-premise instance

I have a requirement to copy the azure managed sql service db into an on-premise instance. But when I searched on the topic, I am able to find options for migrating on-premise to azure managed service instance. But not the other way around. …
Subramanian
  • 67
  • 1
  • 10
0
votes
1 answer

ServerName for Get-AzSqlDatabaseLongTermRetentionPolicy and Set-AzSqlDatabaseLongTermRetentionPolicy with Azure Managed Instance

I am trying to set LTR on databases in our Managed Instances via the above listed Az commandlets. The problem I am having is determining what the ServerName parameter should be. If I try to use the ManagedInstanceName or…
Timothy Murphy
  • 46
  • 1
  • 12
0
votes
1 answer

Import data from a file in a shared folder location to SQL Managed Instance?

I've been trying to import data from a file into a table in SQL Managed Instance. I was able to successfully import data from a text file and an Excel file that I uploaded in a Blob container in Azure Storage to my desired tables in SQL Managed…
Abdinassir
  • 11
  • 3
0
votes
1 answer

Unable to provide access to Key Vault for Managed instance using powershell

I have a requirement to grant and remove access to TDE keys in Keyvault for Managed Instances using powershell. As per the below documentation, Microsoft suggests to use the below code to get the objectid of the Managed instance and use it to set…
Midhun C N
  • 166
  • 1
  • 9
0
votes
0 answers

SQL Server Snapshot replication - Failing to start the Publisher snapshot agent

I am trying to set up a Snapshot replication using an Azure SQL Managed Instance. While trying to see the Snapshot Agent status, I see this error. "Access to the path '\unc\XXXXXXXX-MANAGEDINSTAxxxxxxx_XXXXXXX_PUBLICATION\20200708132018' is…
Ajeesh Joshy
  • 1,387
  • 2
  • 18
  • 32
0
votes
1 answer

Azure SQL Does not allow login for Created Clients

I created several users for Azure SQL using the free acccount in a database in Azure Data Studio following the recommended procedure: add client ip addresses to firewall create login on the master database create users add appropriate roles that at…
Andrew Scott Evans
  • 1,003
  • 12
  • 26
0
votes
0 answers

SQL Server Linked Server not returning all results

I'm trying to read data out of a from a linked server and the join is bringing back only the first match. If I ran the query on the directly on the remote server I'd get multiple rows back. Both the local and remote servers are Azure Managed…
user2197446
  • 1,065
  • 3
  • 15
  • 31
0
votes
1 answer

Multiple SQL instance on Azure

I'm preparing a migration plan to migrate on-premises SQL Server to Azure. On our on-prem there are two sql instance (DevSQL01\Dev and DevSQL01\Demo) running on single VM. Can we create a same scenario on azure, i.e. can we create two SQL instance…
Jagan Sekaran
  • 78
  • 2
  • 7
0
votes
1 answer

AZURE SQL MI Error: Stale/aborted version cleanup was aborted for database id '10' due to database shutdown

I am trying to restore SQL server .bak file to Azure SQL Managed Instance database through SSMS but getting an error Msg 22003, Level 16, State 1, Line 18 Stale/aborted version cleanup was aborted for database id '10' due to database shutdown. Msg…
Hemant Sudehely
  • 49
  • 1
  • 10
0
votes
1 answer

Azure SQL: Group a result based on a sub select statement

I have an issue with a query where I want to accumulate values and then group them PS: This is a simplified example CREATE TABLE [dbo].[OWNER]( [personId] [int] NULL, [ownerId] [int] NULL, [firstName] [varchar](255) NULL, [lastName]…
Julle203
  • 3
  • 1
0
votes
1 answer

Elastic job agent should work with Azure Manage Instance database?

Actually In azure we are using Azure SQL Manage Instance. In or organization one MI server having similar 3 database with different name. Now we need to setup SQL jobs which run against all this three database. If we use SQL agent of MI then we need…
NP007
  • 659
  • 8
  • 21
1 2 3
…
17 18