Page History
- SQLsafeCmd RestoreFileListOnly <backup_archive> [options]
- SQLsafeCmd RestoreFileListOnly TSM [options]
| Action | Description |
|---|
...
-BackupLocation <filename>
...
<filename> - the filename pattern to restore.
The most recent backup file matching this pattern will
be restored.
Set this to TSM for Tivoli Storage Manager.
...
| <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 |
|---|---|
| - |
...
<name> - SQL server instance name.
Note: it is not required if instance is the default instance on the target server.
...
Move the database logical database file to the physical target file.
<logical_filename> - the database logical database file.
<target_filename> - the physical target file .
Corresponds to the WITH MOVE option in the RESTORE DATABASE T/SQL command.
| 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 |
|---|
...
| - |
...
The security model used to log into SQL Server.
<model> - Integrated or SQL.
Note: Integrated (Windows authentication) is the default.
...
| 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 |
...
Instructs SQL Server to continue the operation despite encountering errors such as invalid checksums.
Note: SQL 2005 and later only.
...
-IncludeLogins
...
. |
...
...
Preserves replication settings when restoring a published database to a server other than that on which it was created.
...
<email_address> - an e-mail address(es) to send a notification via SMTP.
Note: multiple addresses may be separated by spaces, semicolons, or commas.
...
Specifies the mode in which to leave the database after the operation is completed.
<mode> - NoRecovery or Standby.
Note: for Standby mode an undo file may be specified with the -UndoFile option.
...
On a network file error, retry every certain amount of time.
<interval> - retry from every certain amount of time in seconds.
<retry_time> - retry up to certain amount of time in seconds.
<total_time> - total retry time allowed in minutes.
...
<filename> - specifies the ABSOLUTE path to the undo filename.
Note: for Standby recovery mode only.
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).
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...
...