Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Installation Guide

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.
  • Backup Templates can only be deployed as jobs on SQL Server 2000, because SSIS maintenance plans are not supported in this version of SQL Server.
  • Regular expressions are only supported in Maintenance Plans.

To deploy a LiteSpeed Backup Template

  1. Select the Backup Manager pane (CTRL+1).
  2. 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.
  3. 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 Exclude Databases column to exclude individual databases from 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:

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.

 

Related Topic

Create Backup Templates

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating