Questions tagged [azure-sql-managed-instance]
258 questions
0
votes
1 answer
Migrate databases across Azure SQL Managed Instance
I would like to migrate databases from one Azure SQL Managed instance to another and from Azure SQL Managed instance to Azure SQL DB. What is the best approach for it with minimum downtime for 5TB database?
I have checked a few approaches like:
Data…
Rajan
- 43
- 5
0
votes
1 answer
Linked Server on SQL Server Managed Instance
I have SQL Server Managed Instance. Now I want to get data from on-premises SQL Server to SQL Server Managed instance through linked server on a daily basis.
The on-premises SQL Server has only Windows logins and will provide access through Windows…
Narendra
- 11
- 5
0
votes
1 answer
Deployment template parse failed: 'Required property 'type' not found in JSON. Path '', line, position.'. (Code: InvalidTemplate)
I deployed SQL Managed Instance in Azure using Azure portal, and before actual deploy it has an option of saving template for automation of future deploys, which I did.
Then I deleted managed instance, and now I need to re-deploy it using generated…
Aleksey Vitsko
- 101
- 3
0
votes
1 answer
How to use Azure Data Factory to restore an Azure SQL Database from Azure Blob Storage
I have a vendor who dumps a .bak of our database to their SFTP server each night. I'm using ADF to copy that file each day to Azure Blob Storage. I'd like to be able to restore that database from the blob-stored .bak file to an Azure SQL Database in…
buktseat
- 11
- 4
0
votes
1 answer
Enable SQL MI logs related database drop/delete activity
We have an Azure SQL MI having number of databases on it . We have to enable audit logs of SQL MI from diagnostic settings and also enabled logs by executing queries on MI and sending those logs to event hub. We are getting up logs (select, Execute)…
Tahami Rizwan
- 41
- 4
0
votes
0 answers
Azure SQL Managed Instance Drop/Deletion Event logs
We have an Azure SQL Managed Instance having number of databases on it . We have to enable audit logs of SQL Managed Instance from diagnostic settings and also enabled logs by executing queries on MI and sending those logs to event hub. We are…
Nauman Kyani
- 81
- 5
0
votes
1 answer
Run SQL query against Azure SQL managed Instance using PowerShell
My task is to execute Azure MI database SP using Powershell.
I am using connection string. I believe I am able to login to the SQLMI database using the connection string with PowerShell.
However, I am getting an error while running the SQL. Below is…
user112359
- 11
- 2
- 5
0
votes
1 answer
How can I copy a database in Azure SQL Server to Azure SQL Manged Instance in different Azure Subscription
I created an Azure SQL managed instance using terraform in Azure Subscription A.
I am trying to copy the databases in an existing Azure SQL Server in Subscription B to the SQL Managed Instances I created in Subscription A, please how can I go about…
achustle
- 1
- 1
0
votes
1 answer
how to set bulk_options in openrowset to read PDF files from Azure blob storage?
I have an Azure SQL managed instance and would like to read pdf files(images) from Azure blob storage with openrowset. I'm able to read single file when I specify pdf file names but to read multiple files I'm getting an error.
code:
CREATE DATABASE…
user112359
- 11
- 2
- 5
0
votes
1 answer
How to ADD FILE in SQL Managed instance to create a partition?
I want to create a partition in SQL Managed Instace, therefore I create a file group:
ALTER DATABASE megasqldw
ADD FILEGROUP fg_actividades_2022;
That´s OK.
Then when I try to add a file for this file group:
ALTER DATABASE megasqldw
ADD FILE
(
…
user3319338
- 41
- 1
- 2
- 9
0
votes
0 answers
My managed instance's Extended Event stopped logging new events - what am I missing?
I have an extended event running on a GP managed instance. This is the same one I'm using on-prem - it captures error_reported with severity > 10, keeps 10mb of history. Been using it for a year+ without problems on prem. In Azure, this week it…
mbourgon
- 1,286
- 2
- 17
- 35
0
votes
1 answer
Table with index lookup without seek
From the time SQL Server restarted, following code returns counts of different types of index operations and the time each type of operation was last performed. Every individual seek, scan, lookup, or update on the specified index by one query…
nam
- 21,967
- 37
- 158
- 332
0
votes
1 answer
Storing and Retrieving PDF Files in Azure SQL Managed Instance
I use Azure SQL Managed Instance as DB and ADLS for file storage. Now the requirement is to store few small PDF files (about 200 kb each). Storing and retrieving will be done through .NET.
Which is the best and easiest approach?
Storing the PDFs in…
Iniyavan
- 61
- 1
- 5
0
votes
0 answers
Azure DevOps Azure SQL DacPacTask frozen at Update Database step
I was handed over an Azure DevOps Build Pipeline to modify to work with an Azure SQL Managed Instance database. The current pipeline works perfectly with Azure SQL Server database. (Note that both have exactly same schema and data, Managed Instance…
Amila
- 1
- 1
0
votes
1 answer
Scheduled SQL Server backup ultimately restored to Azure SQL
I have been working in on-premises SQL Server since 1999 and am now trying to engage with Azure SQL.
I have identified one of our SQL DBs that we want to lift into Azure for reporting. (We will be connecting Tableau Cloud and have already verified…
Tom Schulte
- 419
- 1
- 6
- 20