Stack Overflow
Stack Overflow

Questions tagged [azure-sql-managed-instance]

258 questions
0
votes
2 answers

Is there any way to backup TDE enable Azure DB(Managed Instance)

Our requirement is to manual back up of Azure DB(MI) when an event is triggered. This db is TDE enabled. I cannot decrypt and take manual backup as decrypting db takes long time. Is there any way to back up of db (export to Azure storage) manually…
Asad
  • 1
0
votes
1 answer

Azure SQL DB MI doesn't support Windows Authentication

Microsoft documentation states that "Azure SQL Database Managed Instance" doesn't support Windows Authentication, it has to be either SQL auth or AAD auth. Could someone please help me understand why Managed instance doesn't support Windows…
DevOps learner
  • 21
  • 1
  • 2
0
votes
1 answer

What are the possible ways to deploy a SQL 2016 database to Azure SQL Managed Instance?

I have an Azure SQL managed instance ready with me. What all things do I need to configure to deploy a SSMS 2016 database to the managed instance. Can i have a step by step process to perform the deployment? Is there any tool available which can…
Rahul Dev
  • 141
  • 2
  • 17
0
votes
2 answers

How to load Informatica Rejected rows due to 'Database errors' to a relational table

While running a mapping I am getting couple of database errors and jobs failed 1.) Arithmetic Overflow error 2.) Conversion failed when converting date and/or time from character string. This is purely data issue(datatype error and data length…
Venkat
  • 47
  • 7
0
votes
1 answer

Is there a REST API alternative to Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy?

I am currently working on automating the setting of retention policies of databases within an Azure managed instance. At the moment I am using the Azure Set-AzSqlInstanceDatabaseBackupShortTermRetentionPolicy PowerShell Cmdlet. It would be…
Wes Toleman
  • 311
  • 5
  • 12
0
votes
1 answer

How do i login to azure SQL using users identity from a ASP.Net application

I have a ASP.Net application that uses Azure AD Authentication, howver i want to connect to the azure database using the loggedin users identity. "Active Directory Integrated is not working for this scenario. When a user logs into my application…
sainadh Nani
  • 29
  • 2
0
votes
1 answer

Managed Instance SQL Size (8TB General purpose) is per database or per SQL instance

Need to know the database size limit for Azure SQL Managed Instance, is that per server or per database?. I mean can I have 2 databases of 7TB each in one managed instance?
Rakesh Suryawanshi
  • 420
  • 6
  • 17
0
votes
1 answer

How to subtract two datetime values and get the output in HH:MM:SS format in SQL Server?

I want to subtract two datetime values and the output in HH:MM:SS format. If the difference is more than one day, the days count needs to be added to hours. I tried to concat the datediff outputs as mentioned below select concat(datediff(hh,…
Venkat
  • 47
  • 7
0
votes
1 answer

Runbook Powershell Invoke-Sqlcmd SQL Server MI connection

I have a some Powershell code to drop a database on a SQL Server Managed Instance that I would like to schedule via Azure Automation. The code runs fine in the Windows Powershell ISE. #Type the Managed instance admin login $username = …
binway
  • 88
  • 1
  • 11
0
votes
1 answer

Linked Servers in SQL Database Managed Instance

In a SQL Server Managed Instance I have 2 databases (for security reasons both databases have different logins). I need the possibility to allow one database to look into the other one. In a local SQL Server I was able to create a Linked Server to…
Steffen Böttcher
  • 1
  • 1
0
votes
1 answer

Azure Custom Script to restore database from Blob Storage to Managed Instance

I need a post VM deployment script in PS to restore a .BAK file located in a Blob Storage to an Azure Managed Instance. I can manually do it manually using SMSS but I get the following error when trying to restore the file from a SQL query (image of…
Juani Condina
  • 132
  • 1
  • 12
0
votes
2 answers

Create database using SSMS GUI fails for Azure SQL Managed Instance

I have spun up a new instance of Azure SQL Managed Instance which appears to be working. I have then created a Jumpbox virtual machine, as per the docs, to manage various components of the virtual network including the managed SQL instance. I can…
Phil Murray
  • 6,396
  • 9
  • 45
  • 95
0
votes
1 answer

Service Broker External activator with Managed Instance

Is Service Broker External activator supported on managed instances? how to notify an external process like Webjob or Azure function? I am trying to avoid creating a CLR to call a webservice.
Anass Kartit
  • 2,017
  • 15
  • 22
0
votes
1 answer

SQL MI - manual backups failing on databases with encryption ON

anyone came across failing manual backups on SQL MI recently, since yesterday TDE kicked in and databases created had Encryption set to ON? SOLUTION: to explicitly backup database to blob storage you need to set encryption to OFF before triggering…
Databull
  • 11
  • 2
0
votes
1 answer

How to find earliest restore point for database on Azure SQL Managed Instance

Azure SQL Database Managed Instance shows the earliest time when the database can be restored on Azure portal. Is there a way to find it programmatically using PowerShell or Azure CLI?
Jovan MSFT
  • 13,232
  • 4
  • 40
  • 55
1 2 3
…
17 18