Windows (Multipurpose SQL)

volumes:
  msqlsql00:
    DriveLetter: S
    FSLabel: SQL_Server
  msqldb00:
    AccessPath: S:\SQLData
    FSLabel: SQLData
    AllocationUnitSize: 65536
  msqllog00:
    AccessPath: S:\SQLLogs
    FSLabel: SQLLogs
    AllocationUnitSize: 65536

Tip

TempDB is usually stored on an AWS instance store volume as T: or on Azure ephemeral storage as D:. This storage is temporary and must be provisioned after each boot, so it is not provisioned by Ansible.

Use this PowerShell script to provision the AWS instance store volume for TempDB. The script creates a scheduled task that runs at startup to provision the volume. It also handles stopping and starting the SQL Server service to ensure TempDB is properly configured.