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.

Was this page helpful? Yes No Submitting... Thank you

Comments