Online Documentation for SQL Backup for SQL Server
Manage templates effectively
Using the templates tool of EMS SQL Backup you can create saved into EMS SQL Backup configuration policies, tasks, steps and schedules settings.
In order to create a template proceed to the Templates tab and choose an object type (policy, task, step or schedule) which template you want to create. Then click the Add button located on the toolbar or in the context menu.
If you already have a configured policy on a group of databases or servers you can create its template. In order to do this proceed to the Policies tab and select the Create Template from Policy its context menu item.
Also you can create templates of existing tasks, steps and schedules. To do this you need to:
- open the policy including these objects in the policy editor;
- select the Copy to Templates context menu item of the object which template you want to create.
All saved templates can be later used for creating policies.
In order to create a policy based on a template you need to select the Create Policy from Template context menu item of a policies list on the Policies tab. In the Item Selection dialog choose the needed template (or several templates). The policy editor will be opened. All tasks included in the template will be automatically added to the policy being created.
In order to create a task/step/schedule based on a template in a policy use the Add New from Template context menu item or the toolbar corresponding button on the second step of the policy wizard. The added object can be opened in its editor afterwards to change some parameters if needed.
Templates tab contains a list of all predefined templates as well as templates created by user. You can save a template into *.xml file by selecting the Export its context menu item. Also you can load saved templates using the Import button. This ability allows copying templates from one EMS SQL Backup configuration to another.