VSS backup examples

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

Full local backup examples

If you want to complete a full local backup, the following examples are provided to help you model the command syntax.

To complete a VSS full backup of a database (test1) to local shadow volumes using the /backupdestination and /backupmethod optional parameters, enter the following command:
```
tdpsqlc backup test1 full /backupdestination=local 
/backupmethod=vss
```
To complete a VSS full backup of all available databases to local shadow volumes using the wildcard character (*) and the /excludedb parameter to exclude the master and msdb databases from being backed up, enter the following command:
```
  tdpsqlc backup * full /backupdestination=local /backupmethod=vss
 /exclude=master,msdb
```
To complete a VSS full backup of an SQL Server 2012 availability database and later versions (hkaagdb) to local shadow volumes, enter the following command:
```
tdpsqlc backup hkaagdb full /backupdestination=local /backupmethod=vss
```
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
```

Full local backup with IBM Spectrum Protect server example

To complete a VSS full backup of database (model) to local shadow volumes and IBM Spectrum Protect server storage using the /backupmethod parameter, enter the following command:

  tdpsqlc backup model full /backupmethod=vss

Copy-only full backup to IBM Spectrum Protect server example

To complete a VSS copy-only full backup of the full backup of the filestreamdb database to the IBM Spectrum Protect server storage using the /backupmethod parameter, enter the following command:

tdpsqlc backup filestreamdb CopyFull /backupdestination=TSM 
/backupmethod=vss