Page History

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.

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 (64 KB) 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 'Transfer Limit' value set in the SQLSafe agent properties.

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.

Disables the validation of any checksums by the restore operation.

Note: for SQL 2005 and later only.

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.

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.