SQL Safe provides you with CLI commands to help you manually list files for database in backup set.
To perform RestoreFileListOnly operations use the following commands:
- SQLsafeCmd RestoreFileListOnly <backup_archive> [options]
- SQLsafeCmd RestoreFileListOnly TSM [options]
Where:
| Action | Description |
|---|---|
| <backup_archive> | Path to the backup archive. |
| Tsm | Use Tivoli Storage Manager (see below for special options). |
Common Options
The following options help you perform RestoreFileListOnly operations:
Options | Descriptions |
|---|---|
| -BackupSet <index> | <index> - the index of the backup set within the backup archive. (1-based). |
Security Options
Secure your RestoreFileListOnly 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 RestoreFileListOnly 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 RestoreFileListOnly 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 RestoreFileListOnly).