Azure. Automation of tempDB with ARM templates

Asked Feb 26 '17 at 15:15

Active Feb 26 '17 at 15:32

Viewed 106 times

0

I need to automate setting tempDB files on SQL Server 2016 Web Edition with Windows Server 2016 on Azure. Is it possible to do with ARM templates?

asked Feb 26 '17 at 15:15

Max

35
11

are you talking about IaaS? yes – 4c74356b41 Feb 26 '17 at 15:18
Yeah, I need to do it on IaaS. – Max Feb 26 '17 at 15:27

1 Answers1

2

I don't have a template ready, but there are examples on quickstart templates with the VM with DSC extensions (https://github.com/Azure/azure-quickstart-templates/tree/master/dsc-extension-azure-automation-pullserver or https://github.com/Azure/azure-quickstart-templates/blob/master/sql-reporting-services-sql-server/azuredeploy.json#L331-L365), that's the only real way to do that. You would have to create your own DSC resource based on xDatabase resource, or you can copy someone else's work: https://gallery.technet.microsoft.com/xSQLServer-PowerShell-12d76584

answered Feb 26 '17 at 15:32

4c74356b41

69,186
6
100
141