6,664 questions with Azure SQL Database tags

Sort by: Updated
2 answers

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
asked 2025-12-11T23:07:08.4066667+00:00
Justin Doh 860 Reputation points
edited a comment 2025-12-12T19:52:44.5633333+00:00
Justin Doh 860 Reputation points
1 answer

I have a Postgres 11 server (Single server) that does not show up in portal, but is still billed

I have a postgres server gaver11.postgres.database.azure.com that should probably have been migrated from Single to Flexible server earlier, but the web app still works and can connect to the server. However, I can no longer see the server in the portal…

Azure SQL Database
asked 2025-12-12T17:48:55.7766667+00:00
Geir Sagberg 0 Reputation points
edited the question 2025-12-12T19:52:06.24+00:00
Pilladi Padma Sai Manisha 585 Reputation points Microsoft External Staff Moderator
2 answers

SSMS 22 Azure validation and weird email address

I installed SSMS 22 today, and when I try to connect to an Azure SQL Database and server, I get the following prompt with some weird email address. I have NO idea where it is pulling that from. I have ZERO issue with SSMS 21, but with SSMS 22 this is an…

Azure SQL Database
asked 2025-12-11T23:24:16.3466667+00:00
Scott Klein 35 Reputation points
answered 2025-12-12T19:30:42.8233333+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
1 answer

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
asked 2025-12-12T17:34:22.59+00:00
P Christel 0 Reputation points
commented 2025-12-12T19:20:28.19+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer 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
asked 2025-12-12T15:00:16.9333333+00:00
Kim 0 Reputation points
edited the question 2025-12-12T18:54:15.6866667+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
2 answers

Download database data

Hello, we have already cancelled our account, but we would like to download our data to keep it safe. We have already downloaded the WordPress data, but we are unable to download the database data; we receive an error message, see also attachment. How…

Azure SQL Database
asked 2025-12-02T17:27:54.6+00:00
Webmaster 0 Reputation points
commented 2025-12-12T06:30:26.45+00:00
VRISHABHANATH PATIL 2,305 Reputation points Microsoft External Staff 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
asked 2025-12-08T16:01:05.7033333+00:00
P Christel 0 Reputation points
commented 2025-12-11T22:58:57.5266667+00:00
P Christel 0 Reputation points
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
asked 2025-12-05T10:51:40.08+00:00
Henrik 40 Reputation points
commented 2025-12-11T18:42:21.9866667+00:00
Pilladi Padma Sai Manisha 585 Reputation points Microsoft External Staff Moderator
1 answer

Azure SQL Database Hyperscale Serverless

I have a database in Azure. It's an SQL Database that runs only one process per day, just one in 24 hours. When this process runs, it consumes a lot of DTUs and CPU, requiring approximately 4 to 6 vcores. Therefore, I configured this database with a…

Azure SQL Database
asked 2025-12-10T12:50:29.5466667+00:00
Fernando Gutierrez 325 Reputation points
commented 2025-12-11T18:34:17+00:00
Pilladi Padma Sai Manisha 585 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-09T21:50:29.61+00:00
Muhammad Usman 0 Reputation points
commented 2025-12-10T21:31:05.9433333+00:00
Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
1 answer

Issue while importing bacpac file into sql server database

I’m trying to import a BACPAC file into a new SQL Server database. My BACPAC file is stored in an Azure Storage account. When I use the “Import Database” option on SQL Server, I select my storage account and provide the necessary credentials (username,…

Azure SQL Database
asked 2025-12-09T19:32:00.75+00:00
GOGATE, AKSHAY 0 Reputation points
commented 2025-12-10T20:51:38.11+00:00
Pilladi Padma Sai Manisha 585 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Impact of increasing Azure SQL DB size from 500 GB to 1 TB

Dear Experts, I am planning to increase my Azure SQL DB from 500 GB to 1 TB (S4 compute tier) Would there be a performance impact during this time? Or any possibility of an outage? Could you please advise? I saw this link…

Azure SQL Database
asked 2020-08-06T11:09:01.55+00:00
mo boy 396 Reputation points
commented 2025-12-10T11:26:22.5+00:00
Antonio Buonaiuto 21 Reputation points MVP
2 answers

How do you connect to a read-only replica created by Read Scale-Out through an endpoint rather than using ApplicationIntent=ReadOnly

I am trying to connect to and Azure SQL Database Read-Only replica using Power BI, but have run into the issue of it not consistently connecting to the RO Replica. There seems to be no tools to solve this in Power BI so i am left with the only other…

Azure SQL Database
asked 2025-12-04T13:55:00.46+00:00
John Matthews 0 Reputation points
commented 2025-12-10T05:42:06.91+00:00
Pratyush Vashistha 5,125 Reputation points Microsoft External Staff Moderator
3 answers

I need some help with getting data from my SQL MI into my Azure VM

Good day, We are busy moving from on prem solution into Azure. A big issue I have run into is, currently we have automated jobs that takes data from SQL, runs a PowerShell script, creates a CSV where it then gets dropped onto my VM where it can be…

Azure SQL Database
asked 2025-12-02T08:25:49.5033333+00:00
Ziaan Kunneke 0 Reputation points
commented 2025-12-09T10:00:41.8166667+00:00
Saraswathi Devadula 13,485 Reputation points Microsoft External Staff Moderator
3 answers

oracle api connection is generating error of

Hi, I m trying to create oracle api connection from terraform with pipeline , but it is creating error. im giving all values and keys , as per azurerm terraform format. resource "azurerm_api_connection" "oracle_connection" { …

Azure SQL Database
asked 2025-11-27T05:16:46.9533333+00:00
Krishan Nagwan 0 Reputation points
commented 2025-12-09T09:20:24.85+00:00
Kalyani Kondavaradala 4,600 Reputation points Microsoft External Staff Moderator
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
asked 2025-12-04T14:35:27.9+00:00
Chris Vuletich 0 Reputation points
commented 2025-12-08T17:19:30.5466667+00:00
Pilladi Padma Sai Manisha 585 Reputation points Microsoft External Staff Moderator
2 answers

When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error.

When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error. We have tried every instruction in documents we were able to find online. We've created master keys, we've verified…

Azure SQL Database
asked 2025-12-04T17:19:42.7333333+00:00
JoeP 0 Reputation points
answered 2025-12-08T10:59:12.71+00:00
Manoj Kumar Boyini 1,660 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Convert Julian dates in Normal date

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,760 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,713 questions
SQL Server | Other
asked 2024-09-19T18:36:21.3566667+00:00
Vineet S 1,390 Reputation points
answered 2025-12-08T10:17:23.4333333+00:00
Julian Schulz 0 Reputation points
4 answers One of the answers was accepted by the question author.

Is it possible to set up SQL Server cross database queries from Azure SQL dbaas to Azure SQL Managed Instance

I have successfully created cross database queries between databases on the same Azure dbaas instance but is it possible to create cross database queries from a database hosted in our Azure SQL dbaas instance to a database in our Azure SQL Managed…

Azure SQL Database
asked 2025-11-17T16:05:34.19+00:00
Cooling, Steve 45 Reputation points
accepted 2025-12-08T07:59:51.03+00:00
Cooling, Steve 45 Reputation points
2 answers

Elastic Pool Limit Reached

We are having an issue where we are exceeding the request limit of an elastic pool and we have no idea why because when we perform the same task in a test environment the problem does not occur. What we are trying to do is upgrade a database by running…

Azure SQL Database
asked 2025-11-26T12:33:11.62+00:00
developer-0760 0 Reputation points
commented 2025-12-08T06:48:53.91+00:00
VRISHABHANATH PATIL 2,305 Reputation points Microsoft External Staff Moderator