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 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) | -DatabaseName <db_name> | <db_name> - the database to restore . |
Common Options
The following options help you perform RestoreLast operationsRestoreFileListOnly operations:
Options | Descriptions |
---|---|
-DisconnectUsers | Disconnects all users from the target database before the restore operation begins. |
-EncryptedRestorePassword <pwd> | <pwd> - the encrypted password used to decrypt the backup. |
-InstanceName <name> | <name> - SQL server instance name. Note: it is not required if instance is the default instance on the target server. |
-Move <logical_filename> <target_filename> | 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. |
-Password <pwd> | <pwd> - the non-encrypted password used to encrypt the backup. |
BackupSet <index> | <index> - the index of the backup set within the backup archive. (1-based). |
Security Options
Secure your RestoreLast operations RestoreFileListOnly operations with the following options:
Options | Description |
---|---|
-NoPrompt | Never prompt for credentials even if necessary. |
-SecurityModel <model> | The security model used to log into SQL Server. <model> - Integrated or SQL. Note: Integrated (Windows authentication) is the default. |
-SqlUsername <username> | <username> - the SQL Server username (SQL SecurityModel). |
-SqlPassword <pwd> | <pwd> - the SQL Server password (SQL SecurityModel). |
<pwd> - the encrypted SQL Server password generated by EncryptSqlPassword action (SQL SecurityModel).-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 RestoreLast 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. |
-ContinueAfterError | Instructs SQL Server to continue the operation despite encountering errors such as invalid checksums. Note: SQL 2005 and later only. |
-IncludeLogins | For backup, includes the database logins in the backup file. For restore, creates the logins from the backup file on the destination server. |
-KeepReplication | Preserves replication settings when restoring a published database to a server other than that on which it was created. |
-MailTo <email_address> | <email_address> - an e-mail address(es) to send a notification via SMTP. Note: multiple addresses may be separated by spaces, semicolons, or commas. |
-RecoveryMode <mode> [-UndoFile <filename>] | 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. |
-RetryReads <interval> <retry_time> <total_time> | 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. |
-UndoFile <filename> | <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 RestoreLast operationsRestoreFileListOnly 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 restorelastrestorefilelistonly
).
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...