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 Node
  • Apply/Remove Patch
  • Create Clustered Instance (2000)
  • Create Clustered Instance (2005)
  • Create Clustered Instance (2008)
  • Create Clustered Instance (2008 R2)
  • Create Clustered Instance (2012)
  • Create Database
  • Create Instance (2000)
  • Create Instance (2005)
  • Create Instance (2008)
  • Create Instance (2008 R2)
  • Create Instance (2012)
  • Remove Database
  • Remove Instance
  • Remove Node

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.

 

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*