SQL Safe provides you with CLI commands to help you manually list backup sets in an archive.
To perform RestoreHeaderOnly operations use the following commands:
- SQLsafeCmd RestoreHeaderOnly <backup_archive> [options]
- SQLsafeCmd RestoreHeaderOnly TSM [options]
Where:
| Action | Description |
|---|---|
| <backup_archive> | Path to the backup archive. |
| Tsm | Use Tivoli Storage Manager (see below for special options). |
Security Options
Secure your RestoreHeaderOnly operations with the following options:
Options | Description |
|---|---|
| -WindowsUsername <domain\user> | <domain\user> - the Windows user that will be used to read/write the backup archive. |
| -WindowsPassword <pwd> | <pwd> - the password for the Windows user. |
| -EncryptedWindowsPassword <pwd> | <pwd> - the encrypted password for the Windows user generated by EncryptWindowsPassword action. |
Advanced Options
The following advanced options help you perform RestoreHeaderOnly operations:
Options | Description |
|---|---|
| -ArgsFile <filename> | The path to a file containing command-line arguments. <filename> - specifies the file that contains the command line arguments. |
Tivoli Storage Manager Options
There are TSM options for your RestoreHeaderOnly operations:
Options | Description |
|---|---|
| -TsmClientOwnerName <name> | <name> - the client owner name. |
| -TsmClientOwnerPassword <pwd> | <pwd> - the client owner password. |
| -EncryptedTsmClientOwnerPassword <pwd> | <pwd> - the encrypted TSM client owner password. |
| -TsmConfigFile <filename> | <filename> - the configuration file location. |
| -TsmHighLevel <name> | <name> - the high level file specification (path). |
| -TsmLowLevel <name> | <name> - the low level file specification (file name). |
| -TsmTcpServerAddress <address> | <address> - the TCP/IP address for the TSM server. |
| -TsmTcpPort <port> | <port> - the TCP/IP port address for the TSM server. |
For detailed descriptions and available options, see the CLI Help (SQLsafeCmd help RestoreHeaderOnly).