Page History

<point_in_time>

Date/Time {"MM/dd/yyyy hh:mm:ss"} to restore to.

Use Tivoli Storage Manager (see below for special options)

.

<name> - SQL server instance name.

Note: it is not required if the instance is set as a default on the target server.

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.

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

The path to a file containing command-line arguments.

<filename> - specifies the file that contains the command line arguments.

Specifies additional backup archive files to be used for striping backups.

<filename> - specifies the backup archive files.

 Note: use once for each additional stripe.

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.

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.

Preserves replication settings when restoring a published database to a server other than that on which it was created.

<email_address> - an email address(es) to send the notification via SMTP.

Note: multiple addresses may be separated by spaces, semicolons, or commas.

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, Standby}.

Note: for Standby mode an undo file may be specified with the -UndoFile option.

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

.

Note: for Standby recovery mode only

.

On a network file error, retry every <interval> seconds for up to <retry_time> seconds. Total retry time

allowed is <total_time> minutes.

Specifies

the database to 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.

Specifies that a pre-command is expected. No value is expected here, just the presence of the parameter -PreCommandRun.

Note: Optional.

The UNC location and filename of the pre-backup command.

-PreBackupDestination = '\\myserver\safecommands\prebackupcommand.bat'

Note: Optional.

Quits the backup operation if the pre-backup command fails. No value is expected here, just the presence of the parameter -QuitJobPreJobFail.

Note: Optional.

Specifies that a post-command is expected. No value is expected here, just the presence of the parameter -PostCommandRun.

Note: Optional.

The UNC location and filename of the post-backup command.

-PostBackupDestination = '\\myserver\safecommands\postbackupcommand.bat'

Note: Optional.

<object_id> - The TSM object id.

Note: if the object id is provided, high level and low level are not needed

.