6,423 questions with Azure SQL Database tags

Sort by: Updated
1 answer

Azure SQL Firewall

Hi there, I have 2 environments. I'm more of admin on Azure environment (recently made as subscription admin) after which Dev issue - Azure SQL I'm having difficulty to remove IP from Azure SQL Firewall. (Earlier i was able to) today my manager granted…

Azure SQL Database
asked 2025-08-07T12:47:55.9166667+00:00
RJ 326 Reputation points
commented 2025-08-12T05:08:09.2066667+00:00
Kalyani Kondavaradala 405 Reputation points Microsoft External Staff Moderator
0 answers

Azure SQL is getting in sleep mode

I have created one application, where we are trying to login through Google authentication, it seems that azure sql database gets in sleep mode. due to that we are unable to login in first attempt. it get expire and when we try again, it gets logged…

Azure SQL Database
asked 2025-08-12T03:38:15.46+00:00
Dvebrat Tripathi 0 Reputation points
commented 2025-08-12T04:48:00.0733333+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator
1 answer

Background queries executing in sql causing db to go online

Hi, I have a SQL DB that is serverless and not in use except for two times in day (for approx 15 min each). But oddly, I am noticing that the DB stays online (though autopause set to 1 hour) lot more often. I noticed that there are background queries…

Azure SQL Database
asked 2025-08-11T15:14:08.9133333+00:00
sam nick 366 Reputation points
commented 2025-08-12T04:40:41.67+00:00
Alberto Morillo 34,846 Reputation points MVP Volunteer Moderator
0 answers

Best Practices for Migrating Azure SQL Databases Across Tenants

Hi Azure Community, I’m currently working on a project that involves migrating Azure SQL databases from one Azure tenant to another as part of an organizational restructuring. I’m looking for guidance based on Microsoft’s latest recommended practices,…

Azure SQL Database
asked 2025-08-08T19:38:01.2666667+00:00
Singla, Rajat 0 Reputation points
commented 2025-08-11T21:23:37.2833333+00:00
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator
0 answers

Is this one way to reduce the backup cost for sql managed instance?

Hi everyone, We were told that to reduce SQL managed instance backup cost is by having the storage size about 3 times of the storage was used to ensure the storage utilization is not above 31%. For example if the storage used is 115 GB then we should…

Azure SQL Database
asked 2025-08-11T16:23:02.13+00:00
Tan-9136 120 Reputation points
commented 2025-08-11T19:55:11.8133333+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

Azure Restore a backup using TSQL only

My microsoft outlook account is locked because they no longer support VOIP numbers which is what I have for multi-factor auth. I can still login into my SQL server using IP address. In short, no access to azure portal but can access sql server. I need a…

Azure SQL Database
asked 2025-08-07T23:29:09.9666667+00:00
App Developer 5 Reputation points
commented 2025-08-11T18:46:27.3233333+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

SQL Timeout Exceptions During Hyperscale Point-in-Time Restore

In a production environment using a hyperscale database, a point-in-time restore was initiated for a new database to perform a data fix. During the restore process, SQL timeout exceptions were raised by the application, although no other…

Azure SQL Database
asked 2025-08-06T23:02:46.1533333+00:00
Senthil Santhosh Gopal 0 Reputation points
commented 2025-08-11T18:40:34.6433333+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer

Can I access an Azure SQL database in another tenant/subscription when creating a mirrored Azure SQL database?

Is it possible for our customer to mirror an Azure SQL database located within our Azure Tenant when their Microsoft Fabric is in their own Azure tenant?

Azure SQL Database
asked 2025-08-04T11:03:39.7833333+00:00
Andrew HB 341 Reputation points
commented 2025-08-11T18:21:55.15+00:00
Andrew HB 341 Reputation points
0 answers

Question: Disposal of expired SQL Server Backups on Azure

Hello, We use SQL Server on Azure as PaaS - and have configured backup and retention as detailed here: https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql&tabs=portal We're looking for…

Azure SQL Database
asked 2025-08-11T14:53:13.43+00:00
Engineer1 20 Reputation points
edited a comment 2025-08-11T16:42:29.69+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer

How to connect SQL MI Data source as a cloud connection in Power BI Service for scheduled services

I'm able to connect to the SQL Managed Instance using Power BI Desktop without any issues. However, when attempting to create a cloud connection to SQL MI in Power BI service (since SQL MI supports it), I encounter the following error:   I've already…

Azure SQL Database
asked 2025-08-07T18:57:06.5933333+00:00
Anto Francis 0 Reputation points
answered 2025-08-11T14:25:51.08+00:00
Smaran Thoomu 28,225 Reputation points Microsoft External Staff Moderator
0 answers

When will the cancel operation for my SQL managed instance complete not that it's been 4+ days?

While a scaling operation to increase storage for our SQL managed instance was in-progress, we chose to delete the SQL managed instance. The status for the SQL managed instance is 'deleting' but the resource hasn't completed the deletion in 4+ days, and…

Azure SQL Database
asked 2025-08-11T03:02:42.04+00:00
rthompso-cldadmin 0 Reputation points
edited the question 2025-08-11T05:48:49.3133333+00:00
Naveena Patlolla 4,805 Reputation points Microsoft External Staff Moderator
1 answer

Troubleshooting azure sql connection through token w/ sqlclient.

I'm trying to set up an inter-tenant connection from an azure hosted .NET application to an azure Sql database. Let's say the application is in tenant A, and the sql database in tenant B. I would like to do this through token authorization, utilizing…

Azure SQL Database
asked 2025-08-04T22:41:24.7533333+00:00
Whit Rooke 0 Reputation points Microsoft Employee
answered 2025-08-08T21:54:52.3333333+00:00
Whit Rooke 0 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Unable to login to the VM as soon as it is added in Failover Cluster as part of SQL AAG setup

Hi Team, We are unable to login to the VM as soon as it is added in Failover Cluster as part of SQL AAG setup. We have deployed a new and tried the same again we are unable to login to the VM and unable to ping it. This is as part of a new SQL AAG…

Azure SQL Database
asked 2025-01-23T11:39:19.97+00:00
VJ-8370 651 Reputation points
accepted 2025-08-08T11:22:00.35+00:00
VJ-8370 651 Reputation points
1 answer

Understanding the changes in the Root CA change for Azure SQL Database & Azure SQL Managed Instance

Hi Support, Ref Link: https://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql#frequently-asked-questions When must Azure Sql be completed? Is there a specific date? Why is there so little information about…

Azure SQL Database
asked 2025-07-28T04:09:53.7966667+00:00
FU JIE ZHAO 20 Reputation points
commented 2025-08-08T02:21:37.9633333+00:00
FU JIE ZHAO 20 Reputation points
1 answer One of the answers was accepted by the question author.

CHANGE_TRACKING_CURRENT_VERSION is stuck in replica DBs

We have configured some databases in a Business Critical elastic pool And on those, we have change tracking enabled in a few tables. We use that feature to detect data changes (inserts, updated, etc) to our data and refresh some other resources…

Azure SQL Database
asked 2025-07-31T11:23:19.0533333+00:00
Roi Sanchez Riveira 20 Reputation points
commented 2025-08-07T11:55:29.7466667+00:00
Roi Sanchez Riveira 20 Reputation points
1 answer

SSMS new firewall rule for AZURE not allowed for personal accounts - AADSTS500200

If my IP address changes, I am no longer able to use SSMS to create a new firewall rule. It was possible to create a rule for the last 10 years or so, but within the past month, I cannot. I must log into the Azure control panel (using the very same…

Azure SQL Database
asked 2025-08-06T02:48:57.22+00:00
Bill Clark 0 Reputation points
commented 2025-08-08T03:01:34.58+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

SQL Datbase Diff Backup

What mean from Diff backup Frequency? My value set to 12 hours, this mean the database will be backup every 12 hours?

Azure SQL Database
asked 2025-08-06T04:18:34.73+00:00
Handian Sudianto 6,186 Reputation points
accepted 2025-08-07T08:30:00.29+00:00
Handian Sudianto 6,186 Reputation points
1 answer One of the answers was accepted by the question author.

The Azure SQL Database Offline Migration Wizard - does it disable my source db when i start migration

I have SQL server on Azure VM. I have setup the azure database migration services. I am on the last step of the wizard where it says in the documentation downtime starts when I hit start migration. Does it mean that it will destroy, or put the source sql…

Azure SQL Database
asked 2025-08-06T05:32:34.9966667+00:00
Mark Taylor 351 Reputation points
commented 2025-08-08T07:06:35.82+00:00
Mark Taylor 351 Reputation points
1 answer

How to Auto-Scale Azure Elastic Pool Based on CPU Threshold (5-Min Trigger)

Hi Community, I’m currently using an Azure SQL Elastic Pool, and I’d like to implement auto-scaling based on CPU usage. Goal: Scale Up the elastic pool when CPU usage goes above 90% Scale Down when CPU usage drops back below 90% Trigger actions within 5…

Azure SQL Database
asked 2025-08-06T07:36:41.17+00:00
Hardiv Joshi (PredicAire) 0 Reputation points
commented 2025-08-08T03:15:37.54+00:00
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator
0 answers

Unable to delete vnet as it is connected to a database that has been deleted

I am unable to delete a vnet as it references a sql database. The database has been deleted so the only resource left is the vnet.

Azure SQL Database
asked 2025-08-08T11:59:20.56+00:00
Philip Lee 0 Reputation points
edited the question 2025-08-08T12:31:37.6066667+00:00
Saraswathi Devadula 10,855 Reputation points Microsoft External Staff Moderator