Is it possible to create an Azure SQL database with two virtual machine?

Abeer Hayat Khan 66 Reputation points
2022-09-09T23:29:56.993+00:00

i want to create Azure Sql DATAbase having two virtual machine.
please share that its possible or not if yes please share some knowledge base or if not kindly provide a reason.
Thank you.

SQL Server on Azure Virtual Machines
Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,891 Reputation points MVP
    2022-09-10T02:33:54.047+00:00

    Azure SQL Database is a Plataform as a Service (PaaS) offering, is a managed service were Azure takes care of the hardware, updates to the operating system, updates to Azure SQL database, and many other administrative tasks including automated backups and autmatic tuning. With virtual machines you are taking care of the updates to the operating, system, updates to the database engine, indexing strategy, bbackups, and everything is do it your self. Virtual machines are associated with Infrastructure as a Service (IaaS) and very distant of what is considered PaaS.

    With Azure SQL Database, Microsoft is taking care of the hardware, virtual machines and operating system used to host the database. You cannot interact with Azure to decide the virtual machines or hardware where Azure SQL is created. You can only do that with SQL Server instanes but not with Azure SQL database.

    0 comments No comments

0 additional answers

Sort by: Most helpful