Azure SQL Database
An Azure relational database service.
6,746 questions
1 answer
I want to restore my Azure database from a restore point from one day ago, but I can only select up to 1 hour ago
I have accidentally dropped by data it seems, and have spent a couple of hours trying to realise why. Now when I want to restore my DB to yesterdays backup, I cannot despite having a 7 day retention. I can only restore up to 1 hour ago from the dropdown…
Azure SQL Database
asked 2026-02-13T23:03:12.7866667+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(150.4, 35%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Vic Johnston
20
Reputation points
commented 2026-02-14T01:17:18.04+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(16, 2%, 11%)' 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)
Manoj Kumar Boyini
7,430
Reputation points Microsoft External Staff
Moderator
3 answers
Errors Querying DMVs on Azure SQL Database on S0 Service Objective
Hello, I’m having some issues with querying the sys.dm_db_log_info DMV for Azure SQL databases that are on the S0 tier and connected to via Microsoft Entra Managed Identity. The error I’ getting is below: VIEW SERVER PERFORMANCE STATE permission was…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-13T10:27:18.9133333+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(16, 65%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Suyash Dubey
0
Reputation points
answered 2026-02-13T17:11:28.8466667+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
My Azure SQL Database says it is using 25Gb but the actual data is less than 10Gb
My database in Azure is currently giving me this info: But the actual data is around 7.4GB (as per the bacpac file size). Anyway, the size of the LOG seems huge compared to the actual data. I have the same problem in many other databases in the same…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-11T04:06:33.2566667+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, 59%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hazael Mojica
40
Reputation points
commented 2026-02-13T16:21:51.9833333+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
3 answers
How do I resolve the following : An error occurred while fetching firewall rule details. Please try loading the firewall rule again.
I am attempting to add a firewall rule to my SQL database. I get the message : "An error occurred while fetching firewall rule details. Please try loading the firewall rule again" as I access the page. How can I resolve?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-10T18:24:34.19+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(44.800000000000004, 53%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mark Wedderburn
0
Reputation points
recommended 2026-02-12T21:37:53.2333333+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
2 answers
Expected downtime Azure MI
Hello, I have some questions regarding expected downtime when scaling Azure SQL Managed Instance in the Business Critical tier. Specifically the following operations Increasing vCores Decreasing vCores Increasing storage Changing service tier Any…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-09T13:44:09.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(105.60000000000001, 56.00000000000001%, 20%)' 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)
Julie
160
Reputation points
commented 2026-02-12T18:02:11.5733333+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
3,875
Reputation points Microsoft External Staff
Moderator
1 answer
How to migrate from Azure SQL Database to Azure SQL Managed Instance
We have a around 100 databases in Azure SQL database on one logical sql server in one elastic pool. The database range from ~5GB to 400GB in size. We want to migrate all databases to Azure SQL Managed Instance due to reasons like better cross-database…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-03T10:42:55.42+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, 13%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Georg Sieber
5
Reputation points
commented 2026-02-12T17:24:41.96+00:00
Pilladi Padma Sai Manisha
3,875
Reputation points Microsoft External Staff
Moderator
2 answers
unable to connect with sql server hosted in azure from compliant devices with GSA authentication
Hi Team, We've enabled Conditional access policy with MFA & intune compliant devices to access azure resources from entra joined devices , we're able to connect with storage accounts enabled with private endpoint registered with private DNS zones…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-11T13:48:45.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(220.8, 90%, 31%)' 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)
Arnab De
0
Reputation points
commented 2026-02-12T16:54:04.2633333+00:00
Pilladi Padma Sai Manisha
3,875
Reputation points Microsoft External Staff
Moderator
8 answers
Retirement notice: Azure SQL Database 2014-04-01 APIs will be retired on 30 June 2026
We’re constantly making updates to Azure SQL Database APIs to ensure optimal security and performance. As part of these updates, we’ll retire Azure SQL Database API version 2014-04-01 on 30 June 2026. See our documentation for a detailed list of all…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2022-11-02T22:58:09.407+00:00
GeethaThatipatri-MSFT
29,597
Reputation points Microsoft Employee
Moderator
edited the question 2026-02-11T23:34:12.3566667+00:00
GeethaThatipatri-MSFT
29,597
Reputation points Microsoft Employee
Moderator
5 answers
How much disk space is needed for a Transaction Log (T‑Log) backup for a 1.91 TB database?
Recently, we changed some SQL databases on VM EETAZ1-BHL-ERPL from Simple to Full Recovery Model. Following this, we triggered a full database backup. We have a SQL backup policy configured where transaction logs are backed up every 15 minutes. However,…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-01-30T12:51:58.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(278.4, 78%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Raju Kothapally
10
Reputation points
answered 2026-02-11T21:36:09.23+00:00
Erland Sommarskog
132.4K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
How do i increase the timeout for exporting a BACPAC file from an Azure hosted database?
I have a 76GB database I want to export from Azure SQL. After approx. 24 hours of exporting, the process fails with a timeout error. The suggested solution is to use SQLPackage, but after 48 hours, the export file has only reached 2GB in size. There has…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-10T19:38:45.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(160, 3%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Brendon Haughey
40
Reputation points
accepted 2026-02-11T21:08:43.8333333+00:00
Brendon Haughey
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Why am I still getting "This database has reached the monthly free amount allowance for the month" error after changing the database compute tier?
Hi, I created an Azure SQL database with the free tier option initially, it worked great, then I have hit the monthly free limit. Then I proceed to my Azure portal to change the compute tier to DTU basic plan, but the database still giving me the same…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2024-02-26T09:29:56.6533333+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, 3%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFL%3C/text%3E%3C/svg%3E)
FC Lim
20
Reputation points
commented 2026-02-11T12:55:46.3066667+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(108.80000000000001, 31%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bart Kemps
0
Reputation points
1 answer
How to get a invoice reversed on Azure
Hello, I need help with an unexpected Azure billing charge. About three weeks ago, I tried to set up a free Azure SQL Database, but it seems I accidentally created a paid instance instead. I never used the database, but I was billed $211.24. I have…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-11T11:22:10.2266667+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(105.60000000000001, 85%, 20%)' 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)
Samuel Schalkwyk
0
Reputation points
commented 2026-02-11T11:23:30.92+00:00
Samuel Schalkwyk
0
Reputation points
2 answers
Replicate data in near real time from On Prem SQL server to Azure SQL
Hi, I have a scenario wherein I want to replicate the data from a Hyper-V Server 2025 Host with Windows Server 2019 Standard VM and SQL Server 2019 Standard, on premise to Azure SQL database. I was planning across the transaction replication scope:…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-11T05:41:28.4333333+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(169.60000000000002, 68%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB1%3C/text%3E%3C/svg%3E)
BharathKumarS-1759
65
Reputation points
answered 2026-02-11T07:45:25.1733333+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(166.4, 95%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Saraswathi Devadula
14,145
Reputation points Microsoft External Staff
Moderator
2 answers
Intermittent Azure SQL Database Connection Failures on Azure App Service (.NET 8 Linux Containers)
We are experiencing intermittent SQL connection failures from our .NET 8 applications running in Linux containers on Azure App Service, using both: mcr.microsoft.com/dotnet/aspnet:8.0-alpine-3.18-amd64 mcr.microsoft.com/dotnet/aspnet:8.0 (Debian 12…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-05T10:37:55.57+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(307.2, 70%, 39%)' 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)
Nanthakumar S
0
Reputation points
commented 2026-02-10T22:12:43.2066667+00:00
Manoj Kumar Boyini
7,430
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
Azure SQL database password
I forgot my sql database password. And I cannot find the password reset icon in the overview. I need it to connect to Azure data studio. Many thanks PS: Is me being on the free trial version a potential reason?
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2021-11-24T14:04:55.41+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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2026-02-09T19:53:57.7933333+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(150.4, 81%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Muniappan, S. (Saravanan)
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Cancel my reservation
Hi, I need to cancel my reservation SQLDB_RI_17-01-2025_17-30. I need to for various reasons move to Postgres and don't need this reservation anymore. I can't afford to pay for both. I've been a loyal Azure customer and hope you will help. It is…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2025-11-23T16:39:11.1266667+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, 32%, 39%)' 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)
MolyviatisL
21
Reputation points
commented 2026-02-09T15:37:58.17+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(278.4, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Admin
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Azure Elastic Jobs dynamic enumeration includes databases from wrong elastic pool
I'm experiencing an issue with Azure Elastic Jobs where the dynamic enumeration feature is incorrectly including databases from the wrong elastic pool. Setup: - Two elastic pools: "PoolA" and "PoolB" - Target group using…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-01-29T10:58:12.1766667+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(160, 57.00000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Deyvid Todorov
30
Reputation points
accepted 2026-02-10T13:28:17.0233333+00:00
Deyvid Todorov
30
Reputation points
0 answers
Add new Database in new region in Oracle@Azure
Hello, I have opened database Oracle@AZure in SOuthUK and WestUK. I wulod like to add databases in Central France and paired region. Do I need to open a new OCI tenant / subscription using Azure console or could I use existing tenant. Thanks for…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-08T10:07:42.1233333+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, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Guillaume Delannoy
0
Reputation points
commented 2026-02-10T16:00:55.73+00:00
Manoj Kumar Boyini
7,430
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
Unablet Create database Server in East US region
Hi Team, I'm unable to create Azure SQL Database in East US Region. Could you please help me with the resolution ASAP. Regards, Sivakumaran R
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-09T07:23:58.0533333+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(211.20000000000002, 0%, 30%)' 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)
Sivakumaran R
20
Reputation points
commented 2026-02-10T16:00:44.5933333+00:00
TP
149.5K
Reputation points
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
What permissions are required so that members of a security group are able to rename a database using SSMS?
I have a security group called Developers. It has members including the identity providers and is also a member of Data Readers. On the server via the portal, this group is set as Owner. On the server, the Developers group has a login AND is set as a…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,746 questions
asked 2026-02-09T21:06:23.4966667+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, 31%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nichesoft Admin
20
Reputation points
edited an answer 2026-02-10T01:50:42.0733333+00:00
Manoj Kumar Boyini
7,430
Reputation points Microsoft External Staff
Moderator