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

Question

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.

Answer 1

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