Avamar 6 SQL Transactional Schedule

Hello,

You may follow this procedure :

1. Create a Dataset such as SQL1hrinc
a. Select the database to backup
b. Choose incremental as backup type

2. Under Policy, create a New Group i.e., SQL1hrinc
a. Add Dataset SQL1hrinc to the group
b. Select Retention, client etc

3. Under Policy, click on Group and run backup to make sure group meets the requirements

Now, please login to Avamar utility node via Putty as root user

1. Create a batch file in the /usr/local/avamar/bin such as sqlinc and add the following:

/usr/local/avamar/bin/mccli client backup-group-dataset --xml --name=/DOMAIN_NAME/CLIENT_NAME --group-name=/SQL1hrinc

2. Save file and set the execute permissions i.e., chmod 755 sqlinc

3. Run the file and make sure that the backup is performed.

4. As root, type crontab -e and add the following:

*/60 7-19 * * 1-5 /usr/local/avamar/bin/sqlinc >/dev/null 2>&1

5. Save and exit