Dell EMC Avamar for VMware 19.7 User Guide

Scheduling backups of Microsoft SQL servers for log truncation

Scheduled backups of Microsoft SQL servers for log truncation are configured using the following procedure.

1. In the AUI navigation pane on the left, click , and then click Setting.
   The Setting pane is displayed.
2. Click the Dataset tab.
3. Click ADD.
   The Create Dataset window is displayed.
4. In the Dataset Name field, type a name for the dataset.
   The name can include alphanumeric characters (A-Z, a-z, 0–9) and the following special characters: period (.), hyphen (-), and underscore (_), and space. Do not use Unicode characters or the following special characters: ` ~ ! @ # $ % ^ & * ( ) = + [ ] { } | \ / ; : ' " < > , ?
5. In the Plugins list, select the Windows VMware Image plug-in.
6. Click the Options tab, and perform the following steps:
   1. To view advanced options, select the Show Advanced Options check box.
   2. In the Guest Credentials field, type a virtual machine guest operating system user account name and password with sufficient privileges to run scripts before or after the backup.
   3. In the Microsoft SQL Server authentication field, select the type of authentication:
      • NT Authentication uses the credentials that are entered in Guest Credentials for authentication. You must have Windows Authentication enabled on all SQL Server instances. If log truncation is used, the user who is entered here must have sufficient rights to run log truncation on all databases on all SQL Server instances.
      • Application Authentication uses the SQL Server Username and SQL Server Password to log in to the SQL server. The user credentials that are listed here are used to log in to all SQL Server instances running on the target virtual machine.
   4. In the Microsoft SQL Server post action field, identify the post-action options:
      • Type the maximum number of minutes to wait before post-action operations are considered to have failed in the Post Action Timeout (minutes) option.
      • Select the type of post-action operation. LOG Truncation performs log truncation after the backup has successfully completed.
   5. Complete other information in the Options tab as require.
      The Avamar Administration Guide contains further information about creating and configuring datasets.
7. Click the Source Data tab, and then select All virtual disks:
8. Click SUBMIT.
9. If multiple guest VMs are being backed up as part of this backup policy, create a rule that is used to select the appropriate VMs that have log truncation performed.
10. Create a backup policy for the backups.
    During the backup policy creation process, you:
    1. Assign the new dataset to the new backup policy.
    2. Assign a schedule to the new backup policy.
    3. Assign a retention policy to the new backup policy.
    4. If multiple guest VMs are being backed up as part of this backup policy, in the Members pane of the Policy wizard, select Enable Dynamic rule and select the rule that you previously created.
    The Avamar Administration Guide provides more information about backup policies, rules, datasets, schedules, and retention policies.
11. Enable scheduling for the backup policy.