Page History

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

<point_in_time>

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

<name> - SQL server instance name.

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

Move 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 security model used to log into SQL Server.

<model> - Integrated or SQL {Integrated, SQL}.

Note: Integrated (Windows authentication) is the default.

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.

This can be followed by -BackupFile, -BackupSet, or -Password to set individual options for this backup set.

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

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.

Disables the validation of any checksums by the restore operation.

Note: for SQL 2005 and later only.

<email_address> - an e-mail email address(es) to send a 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> <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.

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.

Wait for hydration to complete before returning result of operation.

Note: by default, it is set to return result of bringing database online

.