Backup examples

The following examples are provided to show how the backup command can be entered with various parameters and options.

If you want to use the backup command from the command-line interface, the following examples are provided to help model the command syntax:

To complete a full backup of a database, enter the following command:
```
tdpsqlc backup
```
To complete a full backup of all standard databases, enter the following command:
```
tdpsqlc backup * full /EXCLUDEALwaysondbs
```
To complete a log backup of all availability databases, enter the following command:
```
tdpsqlc backup * log /EXCLUDESTandarddbs
```
For a more complex example, consider the following scenario: There are three AlwaysOn Availability Groups. The first availability group is called AG01 with the following databases:
- AlwaysOn Availability Database called AlwaysOnLegacyDB1
- AlwaysOn Availability Database called AlwaysOnLegacyDB3
The second availability group is called AG03 with the following AlwaysOn Availability Database: AlwaysOnLegacyDB2. The third availability group is called AG04 with the following databases:
- AlwaysOn Availability Database called AlwaysOnLegacyDB5
- AlwaysOn Availability Database called AlwaysOnLegacyDB6
- Standard database that is called SQL_DB1
- Standard database that is called SQL_DB2
To complete a full backup with a database list that matches both standard and availability databases, but excluding standard databases, enter the following command:
```
C:\Program Files\tivoli\tsm\TDPSql>tdpsqlc backup AlwaysOnLegacy*,SQL* 
        full /backupdest=TSM /backupmeth=legacy /EXCLUDESTandarddbs
```
When you use the /AAGName parameter to filter the databases that are backed up, refer to the following scenario with the examples: There are two AlwaysOn Availability Groups. The first availability group is called AG01 with the following databases:
- AlwaysOn Availability Database called AlwaysOnLegacyDB1
- AlwaysOn Availability Database called AlwaysOnLegacyDB3
The second availability group is called AG04 with the following databases:
- AlwaysOn Availability Database called AlwaysOnLegacyDB5
- AlwaysOn Availability Database called AlwaysOnLegacyDB6
When you enter a backup command for all databases, but use the /AAGName parameter to include only databases from AG01 in the backup, enter the following command:
```
C:\Program Files\tivoli\tsm\TDPSql>tdpsqlc backup * full /backupdest=TSM 
        /backupmeth=legacy /AAGName=AG01
```
When you enter a backup command for a database list with wildcards, but use the/AAGName parameter to include only databases from AG04 in the backup, enter the following command:
```
C:\Program Files\tivoli\tsm\TDPSql>tdpsqlc backup AlwaysOn*,SQL* full 
        /backupdest=TSM /backupmeth=legacy /AAGName=AG04
```
When you enter a backup command for a database list with wildcards, but do not match all databases from the specified AlwaysOn Availability Group, enter the following command:
```
C:\Program Files\tivoli\tsm\TDPSql>tdpsqlc back *DB5 full /backupdest=TSM 
        /backupmeth=legacy /AAGName=AG04
```
To complete a differential backup with a database list that matches both standard and availability databases, but excluding availability databases, enter the following command:
```
C:\Program Files\tivoli\tsm\TDPSql>tdpsqlc backup AlwaysOnLegacy*,SQL* 
        diff /EXCLUDEALwaysondbs
```