Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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.

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*