Azure SQL Database
An Azure relational database service.
5,876 questions
2 answers
Azure SQL Import/Export
We have multiple databases within a single server sizing way above 100GB of data hosted in Azure. Normally we tend to restore the same production copy to our non-prod environments using SSMS .backpac method of export and import, however in bigger data…
asked 2024-12-21T14:24:28.0433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chetan Prakash Saraswat
26
Reputation points
commented 2024-12-31T03:45:18.0766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
820
Reputation points Microsoft Vendor
1 answer
sql server create issue
Unable to create sql server in East Us (Free trial). As i am a student and try to use sql server for free only getting this error:--- Your subscription does not have access to create a server in the selected region. For the latest information about…
asked 2024-12-29T17:32:07.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 91%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nitin Sharma
0
Reputation points
commented 2024-12-31T02:41:57.7733333+00:00
Vijayalaxmi Kattimani
820
Reputation points Microsoft Vendor
1 answer
Getting error creating database in SQL Elastic Pool, but can do it through the portal
I have a SQL Elastic Pool, MyPool, configured with 200 eDTUs and 800 GB storage It contains a database, DBPrimary, with data space used = 127 GB, max storage = 300 GB I have another database outside of the pool, DBProd, with data space used = 117 GB, Max…
asked 2024-12-26T21:50:02.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Joe DeNicola
0
Reputation points
commented 2024-12-31T00:14:55.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,625
Reputation points Microsoft Vendor
0 answers
Adding Azure SQL server metric alert via Bicep fails with "Couldn't find a metric named deadlock."
I'm trying to deploy some metrics based alerts, using the sample code provided by the AMBA project. Most of the alerts work fine, but a number of them have the same issue, namely ""Couldn't find a metric named ####. Make sure the name is…
asked 2024-12-30T14:09:07.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 91%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
lmp
0
Reputation points
edited the question 2024-12-30T22:21:16.47+00:00
Erland Sommarskog
114.6K
Reputation points MVP
3 answers
Block ping and telnet Azure SQL database
You can block ping and telnet from public networks to an Azure SQL database, considering that I already have a private link configured?
asked 2024-12-26T18:58:43.73+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 54%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Julian Steven Lavayen Gómez
0
Reputation points
commented 2024-12-30T17:25:17.3633333+00:00
Mahesh Kurva
1,625
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Connecting Azure SQL Database through Spark
I am trying to connect to Azure SQL through a Spark session using spark-mssql-connector but the code keeps erroring out with the message: Could not find driver This is the code : var jdbc_df =…
asked 2024-12-26T05:09:09.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 3%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sachin Nandanwar
45
Reputation points
accepted 2024-12-30T05:23:20.58+00:00
Sachin Nandanwar
45
Reputation points
1 answer
Database XXX on server XXX is not currently available
Today I woke up and tried to use my Azure Development Database but encountered this issue: "Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of…
asked 2024-12-26T20:16:32.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 42%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Antonio Gastelum Quevedo
0
Reputation points
commented 2024-12-30T02:42:05.1633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
2 answers
Azure data studio table designer error execution time out
An error occurred while generating preview report: One or more errors occurred. (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.) at…
asked 2024-12-25T03:46:11.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Ganbaatar Bold
0
Reputation points
commented 2024-12-28T20:19:56.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
14,621
Reputation points
1 answer
Querying Azure SQL Extended Event not returning any data
I created an extended event in Azure SQL database to capture query data. The data is being written to Azure blog storage, and there is definitely data in the files: I verified that data exists by downloading one of the files and opening it in SSMS. I…
asked 2024-12-23T18:53:21.0233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
5
Reputation points
answered 2024-12-27T17:49:41.4133333+00:00
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure Web App: TLS support for OLEDB-driver
Hi I have trouble running a website on Azure, using the Microsoft 'Web App'. The website is unable to connect to the SQL Server database running in the same resource group (received error: "The connection's current state is closed"). …
asked 2024-12-21T02:03:32.4833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 40%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Claes Eriksson
20
Reputation points
commented 2024-12-27T09:21:19.4733333+00:00
Vijayalaxmi Kattimani
820
Reputation points Microsoft Vendor
1 answer
Azure SQL and Logic Apps: Are We Paying for a Managed Service or Managing Azure’s Shortcomings?
Details: I’m Sasha Froyland, founder of Help4Access, and I’m reaching out to the Azure community because my team and I have spent the past six months troubleshooting what should be a "managed" service—Azure SQL Database—and Logic Apps. Instead,…
asked 2024-12-23T03:50:03.9266667+00:00
Sasha Froyland
1
Reputation point
commented 2024-12-26T07:52:52.91+00:00
Vijayalaxmi Kattimani
820
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Fix the azure portal for students
Dear Microsoft Support Team, I hope this mail finds you well. I am writing on behalf of Starex University to address an issue that our students are experiencing while trying to access Azure Portal services. Our institution’s official domain is…
asked 2024-12-25T09:50:55.84+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Ratan Thakur
20
Reputation points
edited the question 2024-12-26T05:09:39.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
16,086
Reputation points
1 answer
One of the answers was accepted by the question author.
Why did my free Azure SQL database disappear?
I spent several days creating a free Azure SQL database, and it used up all the resources for two months to do it. Later in the second month, it disappeared. What's up?
asked 2024-12-24T08:51:35.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Christopher Tillman
20
Reputation points
commented 2024-12-25T22:20:49.96+00:00
Christopher Tillman
20
Reputation points
0 answers
alert not triggering on azure sql
Hi , we configured alert rule for static ,aggregation type average, greater then , threshold 40% on sql db ealier alerts was worked last few days not working this prod db we are facing lot of issue unless see the metrics then we know the cpu status…
asked 2024-12-18T14:04:00.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 85%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Surapally Sravan Kumar
0
Reputation points
commented 2024-12-25T17:43:26.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,005
Reputation points Microsoft Vendor
1 answer
SQL server with Trace flags 2371 and 7745
Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…
asked 2024-12-20T10:18:09.9266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sanjeev K
20
Reputation points
commented 2024-12-24T16:15:03.2166667+00:00
Mahesh Kurva
1,625
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Database export operation stuck at cancelling
Azure SQL Database export operation stuck at EXPORT DATABASE Cancelling in progress: 50% Some 4-5 Hours already, deleted the storage account it was going to be exported to and server is set to private network access already
asked 2024-12-23T19:27:54.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hugo Souza Almeida
20
Reputation points
accepted 2024-12-24T12:45:48.37+00:00
Hugo Souza Almeida
20
Reputation points
3 answers
Azure SQL Ongoing operations cancel
I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress... I have tried to scale database but that didn’t do anything. What…
asked 2022-03-29T18:35:42.133+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 78%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
ronis
21
Reputation points
answered 2024-12-23T19:35:42.1433333+00:00
Hugo Souza Almeida
20
Reputation points
2 answers
How to expand my db for more markets ?
Right now SQL server db is running in one region and right now we have enabled solution for one market, in future we need to roll out for more markets and need to run in multiple regions . When we enable more markets we will millions of records . can you…
asked 2024-12-16T15:51:16.31+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Siva
0
Reputation points
commented 2024-12-23T14:03:29.3633333+00:00
Sai Raghunadh M
1,605
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Azure SQL to Azure SQL Migration using Full & Differential Backup Feasible?
I have to migrate Azure SQL Database completely from one environment to another Azure SQL Database environment. There is no direct network connection between the two environments. Can Azure SQL Database Server backups (Full & Differential Backup)…
asked 2024-12-20T03:31:29.29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 33%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rajeskumar S L
20
Reputation points
accepted 2024-12-23T13:53:57.91+00:00
Rajeskumar S L
20
Reputation points
1 answer
Login failed for user '<token-identified principal>'.
Hello, I am encountering the following error when trying to connect via Microsoft Entra Service Principal in SSMS. I -As Username I am using the Application ID. (I tried with dieguitico0007_hotmail.com#EXT#@dieguitico0007hotmail.onmicrosoft.com but it…
asked 2024-12-16T02:36:55.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Diego Cedeño
0
Reputation points
commented 2024-12-23T02:18:57.0766667+00:00
Vijayalaxmi Kattimani
820
Reputation points Microsoft Vendor