SQL Safe provides you with CLI commands to help you manually restore the most recent full backup of a database from the specified directory.


To perform RestoreLast operations use the following command:
  • SQLsafeCmd RestoreLast [options]


Where the required [options] are: 
OptionDescription

-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.

-DatabaseName <db_name><db_name> - the database to restore.

Common Options

The following options help you perform RestoreLast operations:

Options
Descriptions
-DisconnectUsersDisconnects 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 the instance is set as a default on the target server.

-Move <logical_filename> <target_filename>

To 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.

Security Options

Secure your RestoreLast 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. (SQLSecurityModel).
-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 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: for 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.

-ReportTLogFor backup, 'Yes' reports skipped t-log backups against databases that are in simple mode with a SUCCESS status rather than SKIPPED.
-MaxTransferSize

Specifies the largest unit of transfer in bytes to be used between SQL Safe and the backup media.
The possible values are multiples of 65536 bytes (64KB) ranging up to 4194304 bytes (4 MB). This parameter is used to enable compression on TDE enabled databases only when the MaxTransferSize value is set to 65537 or higher. If omitted, the MaxTransferSize will be taken from the 'TransferLimit' value set in the SQL Safe agent properties.

-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 email address(es) to send the 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, 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 <interval> seconds for up to <retry_time> seconds. Total retry time allowed is <total_time> minutes.

-UndoFile <filename>

<filename> - specifies the ABSOLUTE path to the undo filename.

Note: for Standby recovery mode only.

-KeepCDC

Flag to indicate whether the restore will support the Microsoft SQL Server Change Data Capture (CDC) feature.
The possible values are 1 (CDC restore will be supported) or 0 (CDC restore will not be supported). If the KeepCDC parameter is set to 1 then the CDC enabled database will be restored along with the CDC related artifacts and the Capture and Cleanup jobs will be created with the default options. If the parameter is omitted, CDC restore will not be supported.

Tivoli Storage Manager Options

There are TSM options for your RestoreLast 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 RestoreLast).


  • No labels