Azure SQL Database
An Azure relational database service.
6,674 questions
1 answer
Accidentally deleted azure sql database
Database: DaySpringCare Server: spotlighthealthcaredatabaseserver.database.windows.net Deletion Time: 2025-12-17 ~12:00 UTC BUSINESS IMPACT:Critical business data lost due to accidental resource group deletion REQUEST Point-in-time restore of…
Azure SQL Database
asked 2025-12-20T08:16:40.47+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(6.4, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bernard Mensah
0
Reputation points
commented 2025-12-20T15:17:26.35+00:00
Bernard Mensah
0
Reputation points
1 answer
What is the best way to design a database schema for comparing educational institutes with multiple criteria?
I am working on an education-related project where I need to store and compare information about multiple higher education institutes. Each institute has different attributes such as approvals, location, course offerings, placement statistics, fee…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-20T09:18:44.9366667+00:00
Gunjan
0
Reputation points
answered 2025-12-20T10:31:47.2833333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
0 answers
Transaction log stuck at 100%
Transaction log stuck at 100% CHECKPOINT fails with error 5901 Log reuse wait shows REPLICATION intermittently Replication & CDC disabled Holdup LSN: (988323:4179272:5) Need backend cleanup of orphaned replication recovery unit.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-20T08:52:48.1166667+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(115.19999999999999, 57.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mirajul
0
Reputation points
commented 2025-12-20T10:04:50.5366667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
3 answers
Unable to Enable CDC on Azure SQL Database Using Server Admin Login - Error 22902 "Caller is not authorized"
We are unable to enable Change Data Capture (CDC) on our Azure SQL Database despite using the server-level admin login (DBAdmin) and Entra ID service administrator. Steps Performed: Connected to the master database using the SQL server admin login . …
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-17T14:14:54.9166667+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(70.4, 42%, 16%)' 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)
RM
0
Reputation points
commented 2025-12-19T21:27:20.25+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
4 answers
Cannot establish ODBC 18 Connection via Interactive authentication
I have been unable to create an ODBC interactive connection to an Azure database. The credentials work fine in SSMS and using the SQLCMD. The browser window opens and allows me to authenticate. I have tried using the ODBC manager (32-bit) as well as…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-08T16:01:05.7033333+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(112.00000000000001, 49%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
P Christel
20
Reputation points
commented 2025-12-19T00:46:30.0466667+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(12.8, 24%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pilladi Padma Sai Manisha
920
Reputation points Microsoft External Staff
Moderator
1 answer
Unexpected billing for the Azure SQL Database Service tier Basic
Hi, I have been using the Azure SQL Server Database with the Basic level service tier for many months now. But just for the last month I got the bill of around 200 Euros and the bill was for the SQL Database Single/Elastic Pool General Purpose - SQL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-09T21:50:29.61+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(204.8, 21%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Muhammad Usman
0
Reputation points
commented 2025-12-18T22:55:05.1166667+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Switch Azure SQL Provisioned to Serverless and back to Provisioned
Hi Can we switch Azure SQL from "Provisioned" to "Serverless" and back to "Provisioned" without any data loss / minimal downtime? Wanted to observe how serverless works for a week. Data should never be lost while switching…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-17T20:15:24.1066667+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, 69%, 36%)' 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)
RJ
366
Reputation points
commented 2025-12-18T22:07:25.0533333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
1 answer
Performance improvement in Azure SQL Database
Hi, Our Azure SQL Database is configured with Standard-series (Gen5). Most of the time, we experience performance issues, as shown in the attached snippet. Could you please guide me on how to track down the root cause and suggest possible…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-18T07:34:19.3733333+00:00
MAGUDEESWARAN, THARUNKUMAR
0
Reputation points
answered 2025-12-18T08:03:47.4+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(262.40000000000003, 18%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
VRISHABHANATH PATIL
2,890
Reputation points Microsoft External Staff
Moderator
2 answers
Azure SQL Failover Group cannot add database after geo-replication was removed. Operation fails with FailoverGroupUnableToPerformGroupOperationOnDatabases
Unable to add an Azure SQL Database to an existing Failover Group after stopping geo-replication. Portal shows success, but database count remains 0/1 and Activity Log reports FailoverGroupUnableToPerformGroupOperationOnDatabases
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-18T05:35:52.86+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(304, 80%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sushil Chaudhary
0
Reputation points
answered 2025-12-18T05:46:31.4133333+00:00
VRISHABHANATH PATIL
2,890
Reputation points Microsoft External Staff
Moderator
4 answers
One of the answers was accepted by the question author.
How to back up Azure SQL DB into BAK file?
I am trying to create a Bak file format from Azure SQL DB into Azure Storage (like Blob storage) on a daily basis for an external client. Previously, I had an external client to log into that Azure SQL DB to perform query, but it appears that it is too…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-11T23:07:08.4066667+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(12.8, 39%, 11%)' 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)
Justin Doh
920
Reputation points
accepted 2025-12-17T23:13:31.27+00:00
Justin Doh
920
Reputation points
3 answers
Issue with Query Store Showing “Restricted Text” in Azure SQL Managed Instance
I am experiencing an issue with Azure SQL Managed Instance where some of the long-running queries in Query Store are displayed as “Restricted Text” instead of the actual query text. Details: Environment: Azure SQL Managed Instance I have admin access,…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-17T19:00:48.9733333+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(243.2, 45%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aditya Rangineni
0
Reputation points
answered 2025-12-17T22:34:09.4933333+00:00
Erland Sommarskog
129.4K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Can't find what is preventing auto-pause from working
I have a General Purpose - Serverless database set-up. Auto-pause was initially working, but as of sometime yesterday, it will not pause. I initially found that I had SSMS open and suspected that was the issue. However, it has been closed for hours…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-12T17:34:22.59+00:00
P Christel
20
Reputation points
accepted 2025-12-17T21:31:44.7933333+00:00
P Christel
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Inconsistency in Null Values While copying data from delta lake to AzSQL
We build a ADF pipeline to copy data from delta lake to Azure SQL db. Below are Sink configuration in ADF copy activity Write Behaviour: Insert Bulk Insert Table lock: No Autocreate Table: None enable staging: Yes when the data loaded to sql table, empty…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,792 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
12,002 questions
asked 2024-01-20T03:09:35.68+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(144, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rakesh Reddy
20
Reputation points
recommended 2025-12-17T10:47:54.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(60.8, 22%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JuliaMarvin
17,205
Reputation points
Volunteer Moderator
3 answers
Not able to login to wordpress -Database Error
I was transferring wordpress website from local to live server azure hosting and due to problems with migration plugin my website has crashed and i cannot login to wordpress.Its showing message"Error in Establishing Database Connection".Because…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2022-07-04T20:29:16.863+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(313.6, 87%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Azka Munawar
11
Reputation points
commented 2025-12-17T09:27:53.15+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(243.2, 70%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
calculo de Salario
0
Reputation points
2 answers
Sync Azure SQL Database across Tenants
Hi A customer wants to access some table that we host for them, we don't want then to have access to our database, so we have proposed looking into Sync Azure SQL Database is this available across Tenants (mine and theirs)? Also i need to cost this for…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-03T16:40:32.4733333+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, 65%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Richard Clark
0
Reputation points
commented 2025-12-17T04:30:44.3366667+00:00
VRISHABHANATH PATIL
2,890
Reputation points Microsoft External Staff
Moderator
2 answers
Reconnect Issues in SSMS to Azure SQL DB with Microsoft Entra MFA After Role Reactivation
Connecting to Azure SQL DB with Microsoft Entra MFA from SSMS was successful previously. However, after the role assignment to the Privileged Identity Management Group expired and was re-activated, reconnection from the same SSMS instance fails to invoke…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-04-17T07:06:14.6233333+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, 36%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jermy Hoffman
0
Reputation points
answered 2025-12-17T01:47:49.3466667+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(64, 77%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brendan Cole
0
Reputation points
1 answer
We no longer have access to view our tables in our DB
Hi, So we have a database in our account called "bayer-server-test." After a bit of turnover in our agency, we seem to have misplaced the actual admin credentials to this DB. We do have a user that can connect to the DB, but we can't view our…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-04T14:35:27.9+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(300.8, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECV%3C/text%3E%3C/svg%3E)
Chris Vuletich
0
Reputation points
answered 2025-12-16T19:34:11.86+00:00
Pilladi Padma Sai Manisha
920
Reputation points Microsoft External Staff
Moderator
2 answers
SQL export job stuck
I'm trying to export an SQL-database hosted in Azure, but it gets stuck on 1% and does not seem possible to cancel the export and start again? How do I proceed?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-05T10:51:40.08+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(230.39999999999998, 64%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Henrik
40
Reputation points
edited a comment 2025-12-16T17:50:33.1866667+00:00
Pilladi Padma Sai Manisha
920
Reputation points Microsoft External Staff
Moderator
1 answer
I have deleted a SQL server that needs to be recovered
I have deleted a SQL Server because of redeployment. Before doing the redeployment I have exported the databases to BACPAC files in a storage account, but now it turns out there's no data in these bacpac files.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-12T15:00:16.9333333+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(54.400000000000006, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Kim
0
Reputation points
commented 2025-12-16T17:37:14.8533333+00:00
Pilladi Padma Sai Manisha
920
Reputation points Microsoft External Staff
Moderator
2 answers
Not getting an option to restore serverless Azure sql database in paired region
I have a Azure SQL database (serverless Gen 5) in US west region. I am trying to restore this database from Geo redundant backups in US west central region but not getting an option to restore.
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,674 questions
asked 2025-12-16T17:12:25.33+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(67.2, 67%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Ankit Dwivedi
0
Reputation points
answered 2025-12-16T17:25:30.95+00:00
Pilladi Padma Sai Manisha
920
Reputation points Microsoft External Staff
Moderator