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


  • No labels