428 questions with SQL Server on Azure Virtual Machines tags
How to enable SQL best practices assessments for SQL VMs via Powershell (not CLI)
I am using Powershell and the Update-AzSqlVM cmdlet to enable the features included with the SQL Server IaaS extension. I have been able to successfully Configure Storage via -SqlManagementType 'Full' parameter, but having trouble with the Enable SQL…
SQL Server on Azure Virtual Machines
Preventing Database Deletion in SSMS
prevent accidental database deletions within SQL Server Management Studio (SSMS). Currently, I am exploring options to enforce this restriction effectively implemented a DDL trigger Is the above DDL trigger approach appropriate for preventing…
SQL Server on Azure Virtual Machines
Developer technologies | Transact-SQL
SQL Server | Other
Where can I read the transcript for the Azure SQL
I would like to read instead of listening all the time
SQL Server on Azure Virtual Machines
Health Probe Failing After Azure Load Balancer SKU Upgrade – One SQL Server Unhealthy
We have an Azure setup with a SQL pool containing two SQL servers (SQLServer-0 and SQLServer-1) behind a Load Balancer. The Load Balancer is configured with a custom TCP health probe on port 59999. Everything was working as expected prior to upgrading…
SQL Server on Azure Virtual Machines
How can I increase the size of the data disk on a Windows Server VM running SQL Server?
Hi, I have a Windows Server VM on Azure that is running SQL Server. Its size is Standard E4bds v5 and it was created from the sql2022-ws2022 source image offer. It has a single P30 Premium SSD LRS data disk of swize 1024GiB. I want to increase the size…
SQL Server on Azure Virtual Machines
SQL virtual machine version upgrade
We are currently using SQL virtual machine 2016 version standard edition the end of support is going to reach at July14, 2026. So, we are plaining to upgrade the SQL virtual machine to 2022 version. our Virtual machine size is Standard E8-4ads v5. We…
SQL Server on Azure Virtual Machines
VM Started Automatically to Create/Update/Delete Virtual Machine Extension by SQLVMResourceProviderAuth
I noticed that 3 of my VMs were automatically started by a system process and left running. It seems to be related to creating or updating and then deleting virtual machine extensions by the SQLVMResourceProviderAuth entity. Events (both on the same…
SQL Server on Azure Virtual Machines
How to remove SQL Server 2017 after in-place upgrade to 2022 on Azure SQL VM?
Hi community members, I’ve completed an in-place upgrade of SQL Server from 2017 to 2022 on an Azure SQL VM using this Microsoft guide: Change SQL Server version on Azure VM. The upgrade went fine, and the VM is re-registered with the SQL IaaS Agent…
SQL Server on Azure Virtual Machines
Recovery Pending mode.
Hello, Last night we increased the CPU and RAM size of our production Windows machine running on Azure to optimize performance and manage credits more efficiently. However, after the resize operation, our SQL Server databases have gone into Recovery…
SQL Server on Azure Virtual Machines
With SQL Server 2019, how do you configure PMEM on an Azure VM?
As a DBA relatively new to the Azure VM environment, do you have the ability to configure SQL Server 2019 as described in https://free.blessedness.top/en-us/sql/database-engine/configure-windows/configure-persistent-memory?view=sql-server-ver17. I have…
SQL Server on Azure Virtual Machines
Memory issue on Azure SQL Server VM
Hi Team, Need your help to troubleshoot. high memory issue on one of the SQL Server on Azure Virtual Machine. No other application installed on this VM. its dedicated to SQL only. Here is the existing setting at SQL : Total Memory in VM server: 64…
SQL Server on Azure Virtual Machines
How do I deploy an Azure SQL VM?
I am trying to start up a Windows 2022 VM with Developer's Edition SQL 2022. It's a menu option, so it seems this should be pretty straightforward. It fails with MSSQL Service failing to start -- every time. I am largely taking defaults -- main…
SQL Server on Azure Virtual Machines
BACKUP LOG Write Fail to Azure Storage
Hello, We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below error and these jobs fail intermittently for…
SQL Server on Azure Virtual Machines
Azure Storage
Developer technologies | Transact-SQL
SQL Server | Other
A critical resource (SQL) was deleted from VM. I need to restore it.
The resource related to hosting SQL on a VM was deleted. Is there a way to restore the resource and recover the lost data? It would be ok to reset the VM to a previous state if that is what needed to be done. There is currently a web site outage…
SQL Server on Azure Virtual Machines
Facing Ext_StorageConfigurationSettings_ArgumentError Issue while deploying Azure SQL VM via Bicep – Storage Configuration Error and Default File Path Not Applied
Facing Ext_StorageConfigurationSettings_ArgumentError Issue while deploying Azure SQL VM via Bicep – Storage Configuration Error and Default File Path Not Applied I am deploying an Azure SQL Virtual Machine using Bicep, but I’m encountering an error…
SQL Server on Azure Virtual Machines
How to allow remote connections to SQL server on an Azure VM through an Azure VPN
I have a Virtual machine on my azure network that is accessed by an Azure VPN via a virtual network gateway. I need to allow a user to connect to SQL server on that VM. I dont want to open 1433 and 1434 to the whole internet and the user does not have a…
SQL Server on Azure Virtual Machines
How to provide edition upgrade for existing VM without rebuild
We have an existing Azure VM with SQL Server Express installed and customised. We need to upgrade the SQL Server instance to Web Edition without redeploying the VM. We are licensed through Azure and want to be billed for Web Edition. Can you help us…
SQL Server on Azure Virtual Machines
Need SQL Server 2019 Standard Setup Support for SSRS/SSIS on Separate Azure VM (PAYG)
We have a Linux VM in Azure running SQL Server 2019 Standard (Pay-As-You-Go), provisioned via Marketplace. We're restructuring and moving SSRS/SSIS to a separate Windows Server 2019 VM (also in Azure). During SSRS setup on the new VM, it's asking for a…
SQL Server on Azure Virtual Machines
Data disk space is low
Action is needed immediately to prevent data/application issues. Our SQL data drive is getting full; we have increased the VM to resize the disk but still the vm shows the same size. And the SQL is almost full.
SQL Server on Azure Virtual Machines
Network security group to allow inbound 1433 connections not working as expected in SQL Virtual Machine
Hi all, I'm using the following to deploy a SQL Server virtual machine. This machine allows mixed type authentication and allows external connections. imageReference { publisher: 'microsoftsqlserver' offer: 'sql2022-ws2022' sku:…