6,359 questions with Azure SQL Database tags

Sort by: Updated
0 answers

Azure SQL DB export to .bacpac fails without errors in Import/Export history

Hello, I am unable to export an Azure SQL Database to a .bacpac file in an Azure Storage Account. The operation fails, but no entries are being logged in the "Import/Export history", so I cannot see the actual error message. Goal: Export the…

Azure SQL Database
asked 2025-07-12T01:15:57.68+00:00
ed 0 Reputation points
edited a comment 2025-07-12T03:14:11.3833333+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer

Moving On prem Sql Server Databases to Azure best option

Hello, We are planning to move On prem Sql Server databases which are currently on Sql server 2014 SP1 and we would like to move into AZURE platform. We have currently 5+ databases which are not pretty much used but we need to keep it for future access…

Azure SQL Database
asked 2025-07-10T20:47:42.8133333+00:00
Pds 46 Reputation points
commented 2025-07-12T02:42:17.43+00:00
Pds 46 Reputation points
2 answers

Azure database monthly costs for basic database

Hi i have created database azure for the first time just to share with the other fella in vs code, i use student plan with 100$ credit and i accidentally chose the provision instead of serverless, it quicky ran out the entire credit after 4 -5 days. I…

Azure SQL Database
asked 2025-07-10T04:19:12.13+00:00
Kiet Ho 0 Reputation points
commented 2025-07-12T01:26:30.45+00:00
Kiet Ho 0 Reputation points
0 answers

The schema info could not be retrieved from the schema info table.

When I tried Data Sync feature, It said, Database provisioning failed with the exception "The schema info could not be retrieved from the schema info table. For more information, provide tracing ID ‘cefdeb43-9265-4e4f-81c0-6f653fd66abe’ to customer…

Azure SQL Database
asked 2025-07-11T22:23:19.25+00:00
kazu 0 Reputation points
edited a comment 2025-07-11T23:44:06.4266667+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Received this email: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

I received this email: Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025. It mentions that something in my subscription is using API version 2014-04-01. It doesn't say what specifically. I ran a query in resource graph explorer to…

Azure SQL Database
asked 2025-07-10T19:58:44.5166667+00:00
Marcos Archilla 40 Reputation points
accepted 2025-07-11T20:01:12.45+00:00
Marcos Archilla 40 Reputation points
0 answers

Azure SQL Database 2014-04-01 APIs will be retired

We received an email that the Azure SQL Database 2014-04-01 APIs will be retired. We got this notice because one or more subscriptions is using the Azure SQL Database APIs. I followed the instructions, but I cannot find what resources we have that are…

Azure SQL Database
asked 2025-07-11T17:00:04.29+00:00
Michael Landy 5 Reputation points
commented 2025-07-11T17:11:45.78+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer

How does SQL Server licensing under the IaaS model work for end-of-life versions ?

Specifically, if I have SQL Server 2016 or 2019 running on Azure virtual machines (IaaS) with different licensing models - such as with Azure Hybrid Benefit enabled and without it (using pay-as-you-go for Standard or Enterprise editions) - how is…

Azure SQL Database
asked 2025-07-10T18:57:49.5266667+00:00
$@chin 200 Reputation points
commented 2025-07-11T17:01:37.93+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer

What Happens if Azure SQL Server Itself is Affected During a Disaster?

Hi Team, I have a question regarding disaster recovery planning in Azure, specifically for Azure SQL Database (PaaS). I’m aware that Azure offers built-in automated backups that allow us to restore individual databases to a previous point in time — which…

Azure SQL Database
asked 2025-07-09T15:34:37.7633333+00:00
Dinesh varma 20 Reputation points
commented 2025-07-11T16:58:01.6533333+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Need help to identify usage of Azure SQL Database 2014-04-01 APIs before retirement

We received the notice that the version 2014-04-01 API will be retiring soon. I ran the following query thru Azure Resource Graph Explorer and the results indicate all apiVersions are 2024-05-01-preview. I just want to confirm that there isn't another…

Azure SQL Database
asked 2025-07-11T15:50:05.2866667+00:00
Bridget Hennessy 0 Reputation points
accepted 2025-07-11T16:00:09.5333333+00:00
Bridget Hennessy 0 Reputation points
4 answers

SQL Development in SSMS, Azure Data Studio or Visual Studio (confusion)

I have always used SSMS to do all my administration and sql development But after coming to another company I have been told that I have to develop locally in Visual Studio. Then publish to the development database and to GIT. To me that means I have…

Azure SQL Database
asked 2022-01-28T09:21:40.137+00:00
Debbie Edwards 526 Reputation points
answered 2025-07-11T11:20:34.87+00:00
Tak Leung Alex Lam 0 Reputation points
0 answers

Connection was denied since Deny Network Access after adding private endpoint

Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes…

Azure SQL Database
asked 2025-07-09T04:27:23.1666667+00:00
21887231 0 Reputation points Microsoft External Staff
commented 2025-07-11T03:24:13.2166667+00:00
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator
0 answers

SQL Managed Instance to Azure SQL DB Replication Failing Out of now where.

Seeing the error on my SQL managed instance: 2025-07-08 22:25:44.939 The remote server "ifpsql3.b37eef63d7.database.windows.net" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available…

Azure SQL Database
asked 2025-07-08T22:56:52.5566667+00:00
David Hancock 0 Reputation points
commented 2025-07-10T20:57:39.8333333+00:00
Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
1 answer

Checking Azure SQL Database API Usage Before Retirement

An internal team has confirmed that the SQL API is not being called directly in the code. However, to ensure there are no backend usages, what steps can be taken to verify the absence of SQL API usage? Additionally, if no usage is found, is it safe to…

Azure SQL Database
asked 2025-07-08T17:35:46.5566667+00:00
TaraK 0 Reputation points
commented 2025-07-10T19:38:40.98+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
2 answers

Storage reclamation of log file in Hyperscale database due to unused allocated space.

My log file is over 1 TB on my hyperscale database, far beyond our typical usage. I’ve cleared old data and am requesting support to reclaim unused allocated storage in Hyperscale to reduce billing impact.

Azure SQL Database
asked 2025-07-10T11:52:04.4433333+00:00
Jeff Mueller 0 Reputation points
commented 2025-07-10T19:21:29.05+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer

Updating Availability zone of SQL elastic pool fails

Attempting to update the SQL elastic pool to zone redundant fails with the following error: (ProvisioningDisabled) Provisioning of zone redundant database/pool is not supported for your current request. Code: ProvisioningDisabled Message: Provisioning of…

Azure SQL Database
asked 2025-07-08T11:34:08.44+00:00
J Ramos 0 Reputation points
commented 2025-07-10T19:02:27.2833333+00:00
Oury Ba-MSFT 20,936 Reputation points Microsoft Employee Moderator
0 answers

One or more unsupported elements were found in the schema used as part of a data package. Error SQL71501

Once a month I export SQL database to storage by Azure and never have an issue. But for the first time, I received this error which I can open the View in my SQL management without any issues The ImportExport operation with Request Id…

Azure SQL Database
asked 2025-07-10T13:51:54.4933333+00:00
Amardeep S 0 Reputation points
commented 2025-07-10T16:29:49.22+00:00
Amardeep S 0 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Database Compute

Hi, I have setup a free SQL Database with the free database offer "First 100,000 vCore seconds and 32GB of storage free per month.". I have set this up for a Web App service that I am developing and literally only logged into the application a…

Azure SQL Database
asked 2025-07-10T03:48:42.44+00:00
Shane Fryer 40 Reputation points
accepted 2025-07-10T05:19:10.6833333+00:00
Shane Fryer 40 Reputation points
0 answers

Trying to delete SQL db. Interfering issue with Elastic Job Agent-SSMS Err:37106. Need help removing orphaned JobDB registration on Azure SQLServer. Copilot and other online resources have defaulted to I need to contact Microsoft Support (Azure Support).

I am attempting to delet a Azure SQL database in our company's Azure tenant. When I try to delete the database from Azure admin portal or Drop the database from within an SSMS I get the following error: “Unable to delete database due to orphaned Elastic…

Azure SQL Database
asked 2025-07-09T18:27:13.1433333+00:00
Dan Krob 0 Reputation points
commented 2025-07-09T18:54:06.5233333+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator
1 answer

How to upgrade Azure SQL Database API version from 2014-04-01 before retirement?

Hello, I received a notification that the 2014-04-01 API version for Azure SQL Database will be retired by 31 October 2025, and I need to upgrade to a newer stable version to avoid service disruption. Here are the details of my resource: Resource…

Azure SQL Database
asked 2025-07-03T14:46:50.63+00:00
Moazzem Hossain 0 Reputation points
commented 2025-07-09T17:46:00.5533333+00:00
Saraswathi Devadula 7,415 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025

I’m using Power Automate to connect to a SQL database for reading and writing data when a record is created or updated. Will this setup be impacted by the upcoming API retirement? if yes, what'd be the migration method? Thanks, DW

Azure SQL Database
asked 2025-07-07T18:15:06.03+00:00
Dongwook Kim 0 Reputation points
edited an answer 2025-07-09T17:32:12.72+00:00
Mahesh Kurva 5,540 Reputation points Microsoft External Staff Moderator