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: 
ActionDescription
<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).



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels