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
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
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

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

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
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
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
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
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
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
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
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
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
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
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
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
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


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


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
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.