SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
356 questions
356 questions with SQL Server on Azure Virtual Machines tags
1 answer
One of the answers was accepted by the question author.
Downgrade SQL SErver 2016 Enterprise to sandard edition hosted on Azure VM
Hi All, I have a Prod Azure VM which has SQL Server 2016 Enterprise Edition installed from Marketplace. SQL license itself costs 3000 AUD. I want to downgrade from SQL Server 2016 enterprise to SQL Server 2016 Standard Edition as Standard Edition will…
asked 2020-07-20T04:38:56.023+00:00
Shivendoo Kumar
736
Reputation points
accepted 2020-07-22T04:39:11.08+00:00
Shivendoo Kumar
736
Reputation points
2 answers
How we can manage multiple DB for different customers using single SQL server hosted in Azure ..? Can anyone suggest a better solution for this ..?
Our aim is to reduce the SQL server licensing and hardware cost also for the high availability of the servers.
asked 2020-07-08T20:22:55.16+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, 91%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
favas vj
1
Reputation point
commented 2020-07-15T20:42:36.35+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Monitoring of SQL Server hosted in virtual machines
Is it possible to create Azure alerts to monitor SQL servers on virtual machines for metrics like deadlocks ?
asked 2020-07-14T14:34:34.153+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, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETE%3C/text%3E%3C/svg%3E)
Tochukwu Ezeokoli
1
Reputation point
commented 2020-07-15T12:15:59.04+00:00
Tochukwu Ezeokoli
1
Reputation point
2 answers
Log shipping
Dear experts I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can connect automatically to DR database…
asked 2020-06-29T05:40:19.84+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, 62%, 32%)' 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)
mukki mehra
1
Reputation point
answered 2020-06-29T12:55:40.187+00:00
Ronen Ariely
15,096
Reputation points
1 answer
Self Install SQL Server On Azure VM With SQL Server Standard Server-CAL License Model
Hi everyone, I have a SQL Server 2019 Standard License (Server+CAL License Model) without Software Assurance. I created a new Azure VM to self install SQL Server. I have some question below: With my license, I will upload a SQL .iso setup file…
asked 2020-06-23T06:22:19.193+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(288, 63%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENT%3C/text%3E%3C/svg%3E)
Nghia To Duc
1
Reputation point
commented 2020-06-23T08:43:11.427+00:00
Leon Laude
85,666
Reputation points
1 answer
Azure SQL VM's in Availability Set
Hello, I have a question regarding Azure Availability Set and specifically related to Azure SQL VM's. Assume I have the following configured in Azure: SQLRG (name of resource group) SQLVM1 (sql vm 1) SQLVM2 (sql vm 2) SQLAS (name of…
asked 2020-06-20T16:48:52.077+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(224.00000000000003, 48%, 31%)' 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)
sydney
1
Reputation point
commented 2020-06-22T20:38:02.277+00:00
msrini-MSFT
9,256
Reputation points Microsoft Employee
2 answers
Find creator of SQL Server trigger
I am a SQL Server sysadmin. Someone created a trigger in a table of the database "msdb". Now how can I find who has created that trigger? Let me know the SQL query or some other trick.
asked 2020-02-06T15:39:44.863+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, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sunny Singh
1
Reputation point
answered 2020-06-11T04:37:48.16+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, 96%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
Uri Dimant
206
Reputation points
1 answer
Restore backup of sql database taken to azure recovery services vault to different subscription
I have registered a test server in a Recovery Service Vault and setup a SQL Database backup policy to a VM running SQL Server. The backup is occurring as expected. Now I would like to restore the backup taken from this server and restore it to a VM…
asked 2019-12-11T17:00:35.147+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(64, 68%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Bargsley, Garry
1
Reputation point
commented 2020-06-01T01:13:43.013+00:00
Ronen Ariely
15,096
Reputation points
1 answer
How to limit DTU per job/task for SQL on Azure
Hello I am wondering if there is a way to set a limit on a per job or task basis that a job or task on a SQL DB that is hosted on Azure. So, something like.... Weekly backup is limited to consuming 10% of available DTU Currently we have a…
asked 2019-12-12T18:37:20.563+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(304, 97%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jason Johnson
1
Reputation point
answered 2020-06-01T00:44:56.607+00:00
Ronen Ariely
15,096
Reputation points
1 answer
One of the answers was accepted by the question author.
Virtual machine scale sets for web servers - back end SQL server AG
Hello All, Hope safe and well We are planning to use VM scale set for web servers as front end and back end covered by SQL Server always on on VM. I need help to understand the deployment of web servers on VM scale set. Deploy a VM with IIS and…
asked 2020-05-28T08:17:38.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(156.8, 7.000000000000001%, 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)
Azurebegginer
146
Reputation points
commented 2020-05-29T11:56:22.147+00:00
Azurebegginer
146
Reputation points
2 answers
One of the answers was accepted by the question author.
How can I migrate my on-premises SQL Server database to the Cloud?
How can I migrate my on-premises SQL Server database to the Cloud? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question.] Source: FAQ
![](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, 28.999999999999996%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Can I install a second instance of SQL Server on the same VM? Can I change installed features of the default instance?
Can I install a second instance of SQL Server on the same VM? Can I change installed features of the default instance? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]
asked 2020-05-13T05:42:49.817+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(217.60000000000002, 82%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sujani Atyam
41
Reputation points Microsoft Employee
accepted 2020-05-13T07:37:44.827+00:00
Sujani Atyam
41
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can I install my licensed copy of SQL Server on an Azure VM?
How can I install my licensed copy of SQL Server on an Azure VM? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]
asked 2020-05-13T05:10:26.223+00:00
Sujani Atyam
41
Reputation points Microsoft Employee
accepted 2020-05-13T05:34:13.947+00:00
Sujani Atyam
41
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Are existing SQL Server virtual machine gallery images updated?
Are existing SQL Server virtual machine gallery images updated? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question.] Source: FAQ
1 answer
One of the answers was accepted by the question author.
What is the difference between SQL Server VMs and the SQL Database service?
What is the difference between SQL Server VMs and the SQL Database service? [Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question] Source : Azure Documentation FAQ Link
asked 2020-05-07T12:05:34.547+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(83.2, 4%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vivek Bezavada
306
Reputation points Microsoft Employee
accepted 2020-05-07T21:30:51.457+00:00
Vivek Bezavada
306
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Options for SQL server Failover Clustering?
Due to some requirements, restrictions and app incompatibility I am being forced into using SQL on VM in azure instead of Azure SQL and Managed Instance. What is the best way to go about failover clustering on Azure VM's for SQL. 2016 or 2019 SQL…
asked 2020-02-17T16:36:42.93+00:00
Goofoff
91
Reputation points
answered 2020-03-05T15:19:38.007+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, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
RENU BISHNOI
1
Reputation point