297 questions
0
votes
1
answer
25
views
How to see/extract SQL MI quota limits for all subscriptions/regions
The Azure Portal does not have anywhere to view the current SQL MI quota limits. Quota limits are set per Subscription/Region pair.
The Quota blade does not contain any of this information.
You may ...
- 598
0
votes
2
answers
87
views
How to Get SQL VM High Availability Replica Role (Primary/Secondary) in Azure via CLI?
I am unable to find the specific command that would return the local replica role(i.e. Primary or Secondary) for a SQL Virtual Machine.
I am able to view this role using azure portal in two ways:
Via ...
- 41
1
vote
1
answer
167
views
Azure SQL Managed Instance randomly freezes/locks up and must be Stopped/Restarted
I am a Developer who is also responsible for Database Administration at my company. We have several Microsoft SQL servers including one Azure Managed Instance SQL server. Recently and at random ...
- 55
0
votes
1
answer
80
views
Creating an Azure Policy to automatically give any SQL Managed Instance Databases a LTR instead of manually assigning them to each database
I wanted to create a policy that automatically gives databases a long term retention instead of doing it manually every time so I created this code but for some reason the database does not get any ...
- 1
0
votes
1
answer
73
views
Getting Invalid Field Size error using ODBC for column of datatype varchar(max)
I migrated a database to an Azure SQL Server Managed Instance.
When I try to do a SELECT on a specific column, I get this error:
Invalid Field Size
The column is defined as VARCHAR(MAX).
I get no ...
- 1
0
votes
0
answers
80
views
I get an error when trying to use bicep to do a point in time restore on a sql managed instance where the source DB is in a different location
We have 2 different Azure SQL managed instance servers.
The point in time restore source server is located in the west us region in its own resource group (rg-sqlmi-source)
The target server is ...
- 63
0
votes
1
answer
54
views
Azure SQL Partition existing table with an integer field as partition field
I am using Azure SQL database to store data. As the dataset is really huge and it keeps growing day by day, I am looking out a way to partition the existing table based on a integer field. Below is ...
- 499
0
votes
1
answer
40
views
Create table in tempdb in SQL Server managed instance secondary instance
I have a SQL server managed instance on Azure with failover group setting. The secondary instance is a read-only database.
It seems that I can't create tables in the tempdb on the secondary instance, ...
- 1,083
0
votes
1
answer
193
views
Error: Code="NetcfgSubnetRangesOverlap"; Subnet is not valid because its IP address range overlaps with that of an existing subnet in virtual network
I am provisioning a sqlmi instance in azure, and we have 2 subnets created. Primary subnet and secondary subnet(DR). The secondary subnet fails to get created with below error. The records are created ...
- 57
0
votes
1
answer
140
views
Azure Database Watcher connected to SQL Managed Instance does not show any SQL Managed Instances in Dashboard and am using sql authentication
I have configured an Azure Database Watcher (preview) to monitor a SQL Managed Instance. After starting the database watcher the Dashboards do not display any SQL Mananged Instance instances.
Here are ...
- 109
0
votes
1
answer
120
views
Dropping a SQL Managed Instance database via Azure Data Factory taking hours
I am trying to drop and restore a database via a script activity in Data Factory.
Drop database activity in Data Factory runs forever, hours.
Database shows up in SSMS, refreshing, reconnecting, ...
1
vote
1
answer
55
views
How can I get the Status of an Azure SQL MI using powershell or REST API?
I am trying to get the status of Azure SQL MI however the Get-AzSqlInstance does not return the status. If running or stopped. What is the easiest way to get this?
-1
votes
1
answer
84
views
Is there a way to recover .bak file while bypassing log files in SQL DBMI?
Can I recover the.bak file on SQL DBMI without recreating a full .bak file using this code on Azure DataBricks?
url2 = 'https:/[REDACTED]/PROD_2009_2round.bak'
# Define restore command using the ...
0
votes
1
answer
150
views
error disabling service broker on SQL Managed instance
I am trying to disable service broker on a SQL Managed instance. When I run this command
ALTER database segenresourcedb
SET DISABLE_BROKER with rollback immediate;
I get these messages:
Msg ...
1
vote
1
answer
56
views
how to find a not null constraint [duplicate]
I am working in Azure SQL Managed Instance. I have a table with some explicitly-named NOT NULL constraints, such as the following:
CREATE TABLE my_db.my_schema.my_table (
my_column int CONSTRAINT ...
- 2,113