Deploy Backup Templates
NOTES:
- A LiteSpeed backup template can only be deployed on a server that has LiteSpeed installed.
- If the target server LiteSpeed version does not support Adaptive Compression, the created jobs and maintenance plans will instead use the specified compression level.
- Regular expressions are only supported in Maintenance Plans.
To deploy a LiteSpeed Backup Template
- Select the Backup Manager pane (CTRL+1).
- In the Backup Templates tab, click Deploy on the toolbar. If you saved the template to file and the central repository is not selected for use, click
beside Backup Templates on the toolbar, select the Deploy option and double-click the template file you want to deploy.
-
Complete the wizard. Review the following for additional information:
Select Instances Use the Show selected instances only option to see server instances and databases where the selected template was deployed.
NOTE: You can select individual databases only if the backup template is saved with the Custom Database Selection at Deployment option.
Backup Options Enter backup destinations for individual instances or for several instances at a time or use the default backup destination you specified in the template.
Use the TLog Backup Location column to enter the Transaction Log backup folder for the given instance.
Use the Diff Backup Location column to enter the Differential backup folder for the given instance.
Use the Exclude Databases column to exclude individual databases from the backup.
Use the TSM Settings column to customize TSM settings for the backup.
You can change the scheduled time manually or you can right-click a cell in the Scheduled Time column and select one of the following options:
- Default to template—To change the current cell back to the template default.
- Default all to template—To change all cells back to the template default.
- Stagger by n minutes—To stagger all scheduled times by n minutes, starting at the template time and adding n minutes for an instance.
- Spread over n hour(s)—To spread the scheduled times evenly over an n hour range, starting with the template time.
NOTE: You can only change the time for the instance.
Each Backup Template remembers if you override these settings to make future redeployments easier. For example, if you specify a different scheduled time for an instance, it will retain the job/plan start time for the next deployments and will not change if you edit this setting in the template.
Notifications If you enabled notification in the template, review the Notification page and complete the fields as necessary. You can use the notification profiles only if they are already configured within a SQL Server instance.
TIP: Variables defined in the maintenance plan can be used to format the Subject Line. There is also help information inside the task that lists the available Subject Line variables.
NOTE: The SQL Server Agent must be configured to send email using Database Mail. Review the following for additional information:
Deployment Type Owner - Optionally, enter the owner of the SQL job (or Maintenance Plan) that will deploy the template. If the name you enter does not exist as a SQL user then the job will fail. If this field is left blank the job will run with the creator of the template or "running" user as the owner.
For each of the selected instances, the Deployment wizard will create either a SQL Agent job or a maintenance plan. Maintenance Plans names and subplans jobs names are prefixed with the template name. SQL Agent job names have the following format: LiteSpeed Backup Template <template_name> (version n).
Tip: To remove a deployed template, run the Deployment wizard, select the Remove deployed template option on the Select Template page and complete the wizard.