Database Administrators

Questions tagged [azure-sql-managed-instance]

Ask Question

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.

25 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

Backup from dacpac file extracted using SSTD

I tried method given in this answer by Ramankant Dadhichi but deploying failed. Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server I have my database in managed ...
0
votes
1answer
48 views

Migrating Azure SQL database to Azure sql Managed instance

What are different options to move database from "Azure sql server" to "Azure sql managed instance", Looks like below options are not possible 1) Azure migration service - Not supporting azure sql ...
1
vote
0answers
42 views

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 ...
0
votes
2answers
56 views

Calculate size of the filtered rows of a table in sql server

My requirement is to know the size occupied(count of records and size in mb) by a table during every 24 hours, I found query to get the whole size of a table but not sure on where to start with or how ...
0
votes
1answer
9 views

SSMS 18.4 Error opening database properties dialog box Azure SQL DB Managed Instance

I have three databases in an Azure SQL DB Managed Instance. I am using SSMS 18.4. One database I can right-click, choose Properties, and the dialog box comes up normally. The other two databases give ...
0
votes
0answers
46 views

How to configure transactional replication for managed instance as a publisher and a subscriber for two different sql server at the same time?

The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher). I then want this subscriber to be a publisher to another subscriber....
0
votes
0answers
23 views

What happens to the transactional replication if azure sql Vm(publisher and distributor) is stopped and restarted from portal?

I am a newbie...I have azure sql vm and sql managed instance. I have setup transactional replication between them. Now if I stop the vm from the portal will the replication still continue after ...
1
vote
1answer
95 views

Does Azure SQL Managed Instance offer SQL Server 2016?

I want to create a SQL Server Managed Instance in Azure that is SQL Server 2016 so I can backup and restore databases across on prem and Azure - i.e. in case we want to back out of Azure, we can do a ...
1
vote
1answer
45 views

SQL server database Role management - Azure SQL MI

In my database I have multiple users with SQL server authentication login and AD login. For ex: User 1 and user 2 are from same team(ABC), if I create a role db_abc User 1 needs read access to table ...
0
votes
1answer
22 views

Change Azure Standard to Premium

I have one application using SQL Server Standard and would like the change to Premium, but I need to understand about the DTU. The application reaches 100% in DTU every day. Would talk know if I need ...
2
votes
0answers
326 views

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 ...
0
votes
1answer
133 views

Validate deployment failed deny policy in SQL managed instance Azure

I am trying to create a manged instance within an existing subnet in Azure. I have configured the subnet with the script provided by Microsoft which tells me the subnet is prepared. When I create ...
0
votes
0answers
49 views

Add a DL as a login in azure sql managed instace

I am able to add individual AD logins as a login in azure sql managed instance, when i try to add a DL is the same way i am getting the following error. error: Principal '' could not be found or this ...
0
votes
1answer
115 views

How to find total used and remaining space in Azure SQL mi

I queried sp_databases and the sum of space occupied by all db's was 380Gb. The total allocated space for the managed instance is 800Gb. But, enquiring with the infra team found that we have only ...
3
votes
2answers
238 views

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 ...
2
votes
1answer
198 views

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 ...
5
votes
2answers
447 views

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 ...
4
votes
2answers
2k views

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 ...
2
votes
2answers
318 views

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 ...
0
votes
0answers
38 views

Azure Managed Instance MSOLAP OLE DB connector

We have a managed Azure SQL instance, and trying to leverage it for some Azure AS documentation. Managed Azure supports OPENROWSET which was going to be used to access DMVs in the SSAS tabular model, ...
1
vote
0answers
172 views

SQL Server Database auditing not working

I'm setting up auditing on a SQL Server Managed Instance in Azure (Version = Microsoft SQL Azure (RTM) - 12.0.2000.8). Following the instructions in the link, everything worked for server-level ...
0
votes
0answers
9 views

Details about existing roles and users in azure sql database

I would like to get details of all users existing in a sql server DB and the respective roles they are part of and the permissions granted/denied for the a role/user. what is the best way to get this ...
1
vote
0answers
445 views

How do I grant permissions for a SQL Server Management Studio user to access system.views in an Azure Managed Instance?

I am connecting to an Azure SQL managed instance with Active Directory through SQL Server Management Studio. I'm trying to access system views, like: SELECT * FROM sys.dm_db_missing_index_details ...
0
votes
0answers
29 views

How to know the size of data returned from a select statement using extended event in azure sql MI?

When a select statement is issued I would like to know the the query issued by the user and the number of rows returned along with the bytes/MB of data returned using extended events. With event ...
1
vote
0answers
51 views

How to Measure data consumed by an user in Azure sql server database?

For an Azure sql server MI, we have multiple external users consuming data, I would like to know how much data an user is consuming/extracting from the DB? Can this be checked from, 1.) From SSMS ...