Azure SQL Database
An Azure relational database service.
5,734 questions
0 answers
How to restore database that are part of azure data sync group?
How to restore on-prem and azure sql database that are part Azure data sync group? When Azure sql database which is part of azure data sync group is restored, the sync group gets deleted automatically? How to restore both on-prem and azure sql database…
asked 2024-10-30T10:49:49.5833333+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
20
Reputation points
commented 2024-11-04T13:47:38.4433333+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
160
Reputation points Microsoft Vendor
1 answer
Azure Data Bases - Job
Hello, I would like help with the following question. I need to create a job or a Debugging task in Azure Data Bases, which runs automatically on certain days and times. I have the Query with Delete, but I need to leave it configured to run…
asked 2024-11-04T13:18:28.5066667+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
180
Reputation points
answered 2024-11-04T13:41:18.0466667+00:00
Olaf Helper
45,016
Reputation points
0 answers
SQL Server Agent in Azure SQL Server
Hello, I would like to know if you can help me with a problem I am having. I have Azure SQL Data Bases which are managed through SQL Management Studio. I need to check some of these Databases to see if they have Jobs configured, but I cannot see the SQL…
asked 2024-11-04T12:29:03.7233333+00:00
Fernando Gutierrez
180
Reputation points
asked 2024-11-04T12:29:03.7233333+00:00
Fernando Gutierrez
180
Reputation points
0 answers
Command 'CREATE LOGIN FROM EXTERNAL PROVIDER' is not supported as Azure Active Directory is not configured for this instance.
We have an SQL Server on an Azure VM. For our main instance, which is our live one, Entra euthentication works without any problem. We can create and login directly using Entra authentication. We also have another instance of SQL on the same server…
![](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(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
1 answer
Can't connect to Azure services through VPN Gateway
Hi, Since this morning, my team and I can't connect to the different Azure services we use, more specifically Azure Database and Azure Storage. We use a VPN Gateway to connect to our Azure Virtual Network in which the different services are connected.…
asked 2024-10-30T17:09:26.5466667+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(124.80000000000001, 67%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Brunet
0
Reputation points
commented 2024-11-04T09:24:54.3433333+00:00
KapilAnanth-MSFT
46,681
Reputation points Microsoft Employee
2 answers
How to keep data consistency for read replica in Azure SQL MI
Hi, I have a question about read replica in Azure SQL MI. The question is how to keep data consistency for read replica? transaction log or something else. Is there any document about this? best regards Jindong
asked 2024-10-30T06:42:23.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(230.39999999999998, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Li, Jindong
46
Reputation points
edited an answer 2024-11-04T08:46:15.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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
15,336
Reputation points
0 answers
Login Issues with SQL Authentication After Enabling Entra ID Authentication
Previously, SQL Server was authenticated using SQL authentication, and I enabled Microsoft Entra ID authentication to allow direct connections to the database via SSMS. I implemented Entra ID authentication without removing the existing SQL…
asked 2024-10-14T06:20:53.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(284.8, 47%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mithila Lishan
71
Reputation points
edited the question 2024-11-04T05:42:19.0766667+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(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
32,991
Reputation points Microsoft Employee
0 answers
The Resource 'Microsoft.Web/sites/vcpbasicplanexpressappwebapp/slots/g4hwaqgebvfedpdn' under resource group 'vcpbasicplanexpressappresourcegroup' was not found.
My current context is Have azure account, subscription to basic plan Locally, I am using MacBook Pro sequoia 15 Backend is express.js sequelize, tedious, migration, works and can connect to a database located in azure sql database. It worked. in order…
asked 2024-11-04T00:57:00.4233333+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, 28.000000000000004%, 40%)' 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)
jclOnana
0
Reputation points
commented 2024-11-04T04:59:24.75+00:00
Vijayalaxmi Kattimani
160
Reputation points Microsoft Vendor
0 answers
asked 2024-10-25T10:49:38.0966667+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, 75%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dharmik Shah
0
Reputation points
commented 2024-11-04T03:34:48.3+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
895
Reputation points Microsoft Vendor
1 answer
Azure SQL Database backups, PITR and LTR with Failover Groups
Let’s say I have two Azure SQL DB servers which participate in a failover group (one server in east, the primary, and the other in west, the read-only secondary). There are roughly a dozen databases on the servers that belong to the failover group. These…
asked 2024-10-30T20:37:59.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(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
0
Reputation points
edited a comment 2024-11-04T03:33:54.81+00:00
Sai Raghunadh M
895
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Database vs Azure Database for MySQL
"I'm working on a project We're considering using either Azure SQL Database or Azure Database for MySQL for the relational data. I've noticed that Azure SQL Database tends to be more expensive. Can someone explain the main differences between Azure…
asked 2024-08-27T22:27:41.3766667+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(0, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Likitha Bommasani
20
Reputation points
accepted 2024-11-01T20:58:05.7066667+00:00
Likitha Bommasani
20
Reputation points
0 answers
Sqlconnectionstring using managed identity in sql trigger
I have an azure function that has a connection string that needs to use the managed identity assigned to it. The managed identity is a user assigned identity. What is the syntax of the connection string ?
asked 2024-10-29T11:42:29.3533333+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, 26%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Diana Boone
26
Reputation points
commented 2024-11-01T17:04:06.8166667+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(265.6, 22%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Shireesha Eeraboina (Quadrant Resource LLC)
5
Reputation points Microsoft Vendor
2 answers
Clients inside the network cannot connect to Azure SQL Database using SQL Studio.
We are trying to establish a connection to an SQL Database on Azure using SQL studio. We are receiving the error message below.
asked 2024-10-23T17:34:09.8233333+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, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Perez, Alexis (ACS)
0
Reputation points
commented 2024-11-01T16:09:55.22+00:00
Oury Ba-MSFT
19,426
Reputation points Microsoft Employee
0 answers
Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table.
Database re-provisioning failed with the exception "The schema info could not be retrieved from the schema info table. For more information, provide tracing ID ‘a991aa28-7145-459b-9530-e009fb53708d’ to customer support."
asked 2024-10-31T19:37:36.5766667+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(256, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
John Tran
0
Reputation points
commented 2024-11-01T15:50:58.5766667+00:00
Oury Ba-MSFT
19,426
Reputation points Microsoft Employee
1 answer
How can I use sys.fn_get_audit_file_v2 (or sys.fn_get_audit_file) to read .sqlaudit files stored in blob storage?
How can I query my .sqlaudit files stored in a blob container within an azure storage account? Details: I have thousands of .sqlaudit files created from Server Audit configurations on over a hundred SQL 2016 and SQL 2019 servers. When I place these files…
asked 2024-10-29T03:00:03.7566667+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(38.4, 85%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nathan Given
26
Reputation points
commented 2024-11-01T13:37:31.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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,950
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Connectivity from Azure extension for SQL Server to DPS is not OK
Hi I'm trying to register my machine / on-prem SQL Server instance with my Azure subscription. I've done it two different ways because the first one failed. In both cases the machine seemed to register successfully (it's visible within Azure Arc), but…
asked 2024-10-30T11:17:34.4533333+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(281.6, 52%, 37%)' 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)
Jonathan Hobdell
20
Reputation points
commented 2024-11-01T12:00:33.6+00:00
Sai Raghunadh M
895
Reputation points Microsoft Vendor
1 answer
Error SQL71621: Azure Key Vault URI '' must be an well-formed, absolute URL
I have an Azure SQL Database using Always Encrypted with the Column Master Key being stored in Azure Key Vault. The project is in Azure DevOps and I am using the Azure SQL DacpacTask to deploy my releases to my dev and prod environments. I am using a…
asked 2024-10-23T18:27:15.0666667+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, 10%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
J B
0
Reputation points
commented 2024-11-01T09:52:36.6933333+00:00
Sai Raghunadh M
895
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
How to copy all tables of a Schema to .csv file format in respective folders
Hi, I am trying to copy all tables of Schema-SALES from SQL Server to .csv file format in ADF and files of each table must copy in respetive folder for example. source (SQL SERVER Tables) SALES.Customer SALES. Address …
asked 2023-12-22T21:18:17.5066667+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, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZH%3C/text%3E%3C/svg%3E)
Zaeemul Haque
25
Reputation points
commented 2024-10-31T15:21:02.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(134.4, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWX%3C/text%3E%3C/svg%3E)
Wenrong Xu
0
Reputation points
2 answers
What is the best way to migrate SQL database to another SQL server in Azure. Minimal downtime.
Hi! I am fairly new to Azure, but have good onprem experience. Asked to migrate two databases (both used by an app) to another subscription/rg/location. Databases are hosted on Azure SQL Logical Serve, that is also the target. Standard tier. So the…
asked 2024-10-12T09:25:12.3266667+00:00
|_SQLViking_|
26
Reputation points
commented 2024-10-31T01:33:33.7566667+00:00
LucyChenMSFT-4874
5,060
Reputation points
2 answers
One of the answers was accepted by the question author.
How to Restore a SQL Database after the Server has been decomissioned
Hi. I have a SQL database on a logical SQL Server that can be decommissioned as the application is no longer used, but I dont want to lose the LTR backups as they need to be retained for 7 years. If I delete the logical server, and I going to lose all…
asked 2024-10-29T09:36:29.29+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, 36%, 20%)' 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)
Bullen, Michael
20
Reputation points
commented 2024-10-30T22:10:35.5433333+00:00
Erland Sommarskog
112.7K
Reputation points MVP