Page History
- SQLsafeCmdBackup <db_name> [<db_name>] <backup_SQLsafeCmd Verify <backup_archive> [options]SQLsafeCmdBackup
- SQLsafeCmd Verify <db_name> [<db_name>] TSM _name> <point_in_time> [options]SQLsafeCmdBackup <db_name> [<db_name>] TRUNCATEONLY
SQLsafeCmd Verify TSM [options]
Action | Description |
---|
<backup_archive> | Path to the backup archive. |
<point_in_time> | Date/Time {"MM/dd/yyyy hh:mm:ss"} to restore to. |
Tsm | Use Tivoli Storage Manager (see below for special options). |
Common Options
The following options help you perform Instant Restore operationsyou verify a database backup:
Options | Descriptions |
---|---|
-BackupSet <index> | <index> - the index of the backup set within the backup archive. (1-based) |
. | |
-EncryptedRestorePassword <pwd> | <pwd> - the encrypted password used to decrypt the backup. |
-InstanceName <name> | <name> - SQL server instance name. Note: it is not required if |
the instance is set as a default |
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. | |
-Password <pwd> | <pwd> - the non-encrypted password used to encrypt the backup. |
-Server <hostname> | <hostname> - the hostname of server hosting the SQL Server where the operation should be performed. Note: this option is required for accessing remote or clustered SQL Servers (where applicable) |
. |
Security Options
Secure your Instant Restore your verification 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, 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). |
-EncryptedSqlPassword <pwd> | <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 Instant Restore operationsverify a database backup:
Options | Description |
---|---|
-ArgsFile <filename> | The path to a file containing command-line arguments. <filename> - specifies the file that contains the command line arguments |
The differential backup.
<filename> - the file path to the differential backup. |
-BackupFile |
-Log <filename>
The log backup.
<filename> the file path to the log backup.
This can be followed by -BackupFile, -BackupSet, or -Password to set individual options for this backup set.
<filename> | Specifies additional backup archive files to be used for striping backups. <filename> - specifies the backup archive files. Note: use once for each additional stripe. |
- |
For backup, includes the database logins in the backup file.
For restore, creates the logins from the backup file on the destination server.
Preserves replication settings when restoring a published database to a server other than that on which it was created.
ContinueAfterError | Instructs SQL Server to continue the operation despite encountering errors such as invalid checksums. Note: SQL 2005 and later only. |
-MailTo <email_address> | <email_address> - an |
email address(es) to send |
the notification via SMTP. Note: multiple addresses may be separated by spaces, semicolons, or commas. | |
-NoStatus | Prevents status messages from being cached or sent to the Repository. |
- |
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.
Specifies that the database be restored to the state it was in as of the specified date and time.
<datetime> - "mm/dd/yyyy hh:mm:ss".
Note: for Log BackupType only.
Specifies recovery to the specified <mark>, including the transaction that contains the <mark>.
Note: for Log BackupType only.
Specifies recovery to the specified <mark> but does not include the transaction that contains the <mark>.
Note: for Log BackupType only.
Recovery stops at the first <mark> having the specified name exactly at or after <datetime>.
Note: only valid with -StopAtMark/-StopBeforeMark options.
For Log BackupType only.
Wait for hydration to complete before returning result of operation.
Note: by default is to return result of bringing database onlineRetryReads <interval> <retry_time> <total_time> | On a network file error, retry every <interval> seconds for up to <retry_time> seconds. Total retry time allowed is <total_time> minutes. |
Tivoli Storage Manager (TSM) Options
There are TSM options for your verification 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 instantrestoreVerify
).
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >
...
...