Managing templates for SQL Server

The Manager enables you to create and manage templates for ease of provisioning and as a means of enforcing standardization across databases and clusters in your environment.

The following template types are available:

Add Database to SQL Server Availability Group
Add Node
Add Replica to SQL Server Availability Group
Apply/Remove Patch
Create Clustered Instance (2008)
Create Clustered Instance (2008 R2)
Create Clustered Instance (2012)
Create Clustered Instance (2014)
Create Clustered Instance (2016)
Create Database
Create Instance (2008)
Create Instance (2008 R2)
Create Instance (2012)
Create Instance (2014)
Create Instance (2016)
Create SQL Server Availability Group
Fail Over SQL Server Availability Group
Remove Database
Remove Database from SQL Server Availability Group
Remove Instance
Remove Node
Remove Replica from SQL Server Availability Group
Remove SQL Server Availability Group

About the standard variables in Microsoft SQL Server templates

The following template variables can be used to populate fields in the corresponding wizard. For example, if a cluster name is entered in step 2 of the wizard, the cluster name can appear as a selectable option or appended to an entry in another area of the wizard.

Template

Standard variable

Details

Create SQL Server Instance

INSTANCE_NAME

The value from the Instance Name field, collected on the first page of the create SQL Server Instance wizard.

DATABASE_NAME

The value from the Database Name field, collected on the first page of the create SQL Server Database wizard.

The following rules apply for standard variables:

All tags can be used for any of the elements defined after the first page.
All tags must be in either the editable or non_editable section of the template except for the SQL Server Database template.

Example

<editable>
          <instance_name>\{INSTANCE_NAME\}</instance_name>
</editable>

For the SQL Server Database template, a template variable can be used for any field.

Note

If you create custom fields, they can also be used as variables in templates. To add custom fields to a template, see Adding custom fields to a template.

Managing templates for SQL Server

About the standard variables in Microsoft SQL Server templates

Comments