Azure SQL Database
An Azure relational database service.
5,975 questions
1 answer
Azure SQL Database Deployment Error after enabling SQL data sync
After enabling Azure SQL Data sync, I am getting below warning while executing DACPAC and deployment if getting failed. I want to Ignore these errors and continue with deployment. Error SQL72032: If this deployment is executed [Foreign key] will be…
asked 2025-02-06T19:06:23.5966667+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, 87%, 34%)' 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)
Aparna Manoharan
40
Reputation points
answered 2025-02-07T15:38:20.06+00:00
Aparna Manoharan
40
Reputation points
1 answer
Azure SQL "Free" database offer not shown
I successfully created a single, "free" Azure SQL database using Microsoft's new free database offer. Then I created another and then deleted it shortly thereafter. Now, two days later, when I create a new SQL database, the offer is no longer…
asked 2025-02-07T14:26:13.0433333+00:00
DavidPendleton-7654
26
Reputation points
edited an answer 2025-02-07T14:57:46.7833333+00:00
TP
102.4K
Reputation points
1 answer
Azure Elasticpool Premium Read Scalet-Out
Hello How are you? I have a question, is it possible that now the Read Only or Read Scale-Out option can be enabled for Azure data bases that are associated within a Premium Elastic Pool? Now I see that the databases that are within this type of Premium…
asked 2025-02-05T12:34:34.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(16, 16%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fernando Gutierrez
245
Reputation points
commented 2025-02-07T13:10:29.6266667+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
1,085
Reputation points Microsoft Vendor
1 answer
Deployment of Azure SQL Managed Instance stuck in Step 3 - New Instance Startup
Yesterday I started to create a SQL Managed Instance (Creation date: 2025-02-04 11:31 (UTC)). I tried to create the SQL-MI in West Europe as General Purpose Standard-series (Gen 5) (4 vCores, 300 IOPS, 64 GB storage, Locally-redundant backup…
asked 2025-02-05T11:29:47.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(105.60000000000001, 33%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Johannes Maly
81
Reputation points
edited a comment 2025-02-07T10:59:33.1433333+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
2,670
Reputation points Microsoft Vendor
0 answers
Error when connecting to Sql Server using Microsoft Sql Server Management Studio
Hi, Team I got an error when connecting to Sql Server using Microsoft Sql Server Management Studio. There was no problem before. Can you help me find out the reason? The following is the detailed error information TITLE: Connect to Server Cannot…
asked 2025-02-07T07:56:36.96+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, 25%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Allen F MAO
0
Reputation points
commented 2025-02-07T09:49:16.7166667+00:00
Mahesh Kurva
2,670
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Guidance With Azure DMS Tool For Maria DB Database Migration
Hello, I am currently working on a Database migration project migrating data from a MariaDB database hosted on AWS over to an Azure SQL DB as part of a cloud consolidation program using an IPsec VPN tunnel. While Azure Database for MariaDB would seem…
asked 2025-01-10T15:48:06.91+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(192, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marc Hedgley
185
Reputation points
commented 2025-02-07T09:42:47.89+00:00
Marc Hedgley
185
Reputation points
1 answer
Metric Storage space used
I see this value in the attached screenshot and would like to clarify its meaning. Additionally, I need to determine how much free storage space is available in my SQL Managed Instance. Ideally, I should see a clear breakdown, such as "10 GB…
asked 2025-02-06T20:27:19.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(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GP
16
Reputation points
edited an answer 2025-02-07T03:10:12.8966667+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
2,315
Reputation points Microsoft Vendor
1 answer
Backup Azure SQL
We have deployed Veeam for Azure to backup out Azure VMs and Azure SQL. We have had no issues backing up our Azure VMs. We cannot get Veeam to backup Azure SQL. I created a login for these backups and given it all the rights Veeam support told me it…
asked 2025-02-04T17:07:52.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(137.6, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Joshua Goodin, MBA
41
Reputation points
commented 2025-02-06T22:04:49.3233333+00:00
Erland Sommarskog
116.5K
Reputation points MVP
2 answers
Azure SQL with intial 5 TB Data storage and it will grow 1TB per year
Hi Team, I have a need to create Azure SQL DB with 5 TB intial storage and it will grow 1TB per each year. For supporting above requirement , which Service tier i should be choosing and it should cost affective. Thanks
asked 2025-02-05T17:26:27.7766667+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, 88%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
Boddu, Naga
20
Reputation points
answered 2025-02-06T19:03:25.4033333+00:00
Alberto Morillo
34,456
Reputation points MVP
1 answer
Bugs in Azure Portal With PITR Restore of a CDC-Enabled Database Between SQL Managed Instances
When using the Azure Portal to the a Point In Time Restore (PITR) of a database on SQL Managed Instance: The restored database does not have the source database’s CDC Capture's Retention period in its [msdb].[dbo].[cdc_jobs] record (it contains the…
asked 2025-01-17T18:55:34.7333333+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(28.799999999999997, 33%, 12%)' 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)
sguidos
10
Reputation points
commented 2025-02-06T18:47:29.3733333+00:00
Oury Ba-MSFT
20,106
Reputation points Microsoft Employee
1 answer
How to download payloads from Azure Cosmos DB efficiently?
I need help figuring out how to download specific payloads from Azure Cosmos DB efficiently. While exploring the Azure interface, I noticed an option to delete data, but I couldn’t find a straightforward way to download it. For example, I want to…
asked 2025-01-23T09:15:43.25+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, 39%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
crynos_001
0
Reputation points
commented 2025-02-06T17:25:36.05+00:00
Sai Raghunadh M
2,315
Reputation points Microsoft Vendor
1 answer
If my bicep code only deploys the resource Azure SQL server do I have to update anything as automatically included resources of type Microsoft.Sql/servers/advisors@2014-04-01 will retire?
We are deploying an azure sql server via bicep template. Our bicep file only includes the resource Microsoft.Sql/servers@2023-05-01-preview. If you take a closer look at the resources exported arm template within the azure portal you will notice child…
asked 2025-02-04T14:06:09.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(3.2, 22%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Admin Florian, Giebel
0
Reputation points
commented 2025-02-06T13:37:55.75+00:00
Vijayalaxmi Kattimani
1,085
Reputation points Microsoft Vendor
2 answers
Upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025
I have received this mail to upgrade Azure SQL Database 2014-04-01 APIs to a newer version by 31 October 2025. When I looked at the ARM template, I found that there are only database advisors who are using the old api version i.e. 2014-04-01. There…
asked 2025-02-03T08:56:00.83+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, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Taukirahmed Khatri
0
Reputation points
commented 2025-02-06T11:19:12.2+00:00
Mahesh Kurva
2,670
Reputation points Microsoft Vendor
0 answers
Importing Azure SQL DB from bacpac - Login Failed
I am attempting to import a database from a bacpac. The database is created, but the process fails shortly afterwards with the following error message: {"code":"ImportExportJobError","message":"The ImportExport…
asked 2025-02-03T17:09:51+00:00
DavidPendleton-7654
26
Reputation points
commented 2025-02-05T18:27:44.6833333+00:00
Sai Raghunadh M
2,315
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
Multitenant private endpoint
I have a subscription in Tenant A that needs to access a SQL database in Tenant B's subscription. To achieve this, I am creating a private endpoint in Tenant B's subscription. What should the architecture look like? And do the VNets in Tenant A and…
asked 2025-02-04T20:56:27.46+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(176, 80%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Merin Mary
40
Reputation points
accepted 2025-02-05T16:31:00.6166667+00:00
Merin Mary
40
Reputation points
1 answer
What are the possible ways to connect an SQL db with Azure AI Search ?
I want to connect Azure AI search with SQL data base, I know it is effective to use azure sql service, but most of my data is on SQL server and the data gets updated frequently, so making copy of my data in azure sql seems inefficient. Is it possible to…
asked 2025-01-10T05:29:45.22+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(316.8, 49%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Adarsh Augustine
0
Reputation points
commented 2025-02-05T06:54:33.7833333+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, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Harshitha Veeramalla
1
Reputation point Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Unstand the migration strategy from Azure SQL Managed instances
Hi Team, Is there any way to migrate our SQL managed instances from one tenant to another tenant. Do we have any detailed documentation regarding this? We should be using azure native tools to perform this lift and shift activity, let us know the…
asked 2025-01-27T11:48:50.8833333+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(131.20000000000002, 30%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
KrupaVani Gundraju
20
Reputation points
edited a comment 2025-02-05T01:37:46.0133333+00:00
Sai Raghunadh M
2,315
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Scalability LEFT JOIN vs MERGE
Hi there, I'm UPSERTING AND handling 70 + millions of rows of UPSERT. I'm the only developer on the DB. GP_Gen5_6 LEFT JOIN DURING UNIT TEST OF ALL RECORDS 12 mins SCALED UP OVERNIGHT PROCESS GP_Gen5_20 History of existing MERGE process same operation…
asked 2025-01-28T17:04:24.43+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
306
Reputation points
edited the question 2025-02-05T01:23:44.56+00:00
ZoeHui-MSFT
40,356
Reputation points
1 answer
One of the answers was accepted by the question author.
ADF - CSV file with more than 2000 columns, need to create multiple tables in the sqlserver using Azure Data factory
I have csv file with more than 2000 columns and 20gb file size. Have to create multiple tables in sqlserver from the csv file using Azure Data factory. here is the file columns col1 col2 col3 col4 col5 col5 ...... i have to create tables with below…
asked 2025-01-31T13:53: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(156.8, 56.00000000000001%, 25%)' 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)
Anil
40
Reputation points
edited the question 2025-02-05T01:22:59.58+00:00
ZoeHui-MSFT
40,356
Reputation points
1 answer
How to get a refund for an azure database that I mistakenly raised to a higher tier
I am a student using your Microsoft tools to learn how to program. When creating a new database, I accidentally used a higher tier. I had no benefit or gain from the upgrade. I would like a refund as this was a complete mistake but microsoft is refusing…
asked 2025-02-04T17:30:05.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(22.400000000000002, 98%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Devora Goldenberg
0
Reputation points
commented 2025-02-04T22:43:15.29+00:00
Erland Sommarskog
116.5K
Reputation points MVP