How to create a Azure SQL VM with separate disks for data, log and tempdb

Matt Griffin 101 Reputation points
2021-01-14T16:51:07.68+00:00

Hi,

I'm relatively new to Azure, having come from a on-prem Windows Server environment, in which I have experience with managing SQL server.

Having moved to a new role, I'm working a project to migrate an on-prem SQL database client-server app to Azure. The design architect has specified the use of an Azure SQL Server VM with separate disks for the data, log and tempdb.

I need to use Terraform to define the environment. I have therefore created a declaration which created a VM built from the microsoftsqlserver/sql2019-ws2019 image. I now need to specify that the various drive locations for the various data types.

Could someone advise how I go about doing this?

Any help would be greatly appreciated.

Matt.

SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,295 questions
{count} votes

Accepted answer
  1. Matt Griffin 101 Reputation points
    2021-01-19T10:31:44.483+00:00

    I believe that I've solved the issue myself.

    I was concentrating on the deployment of the SQL VM and had lost sight of the fact that the data and log files are configured at the point when the database is attached/restored. Therefore it doesn't have any relevance to set these at a SQL instance level.

    Regards

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful