Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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 SQLsafeCmd help restoreheaderonlyRestoreHeaderOnly).



Scroll pdf ignore
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 |
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...