Page History
...
Options | Description |
---|---|
-ArgsFile <filename> | The path to a file containing command-line arguments. <filename> - specifies the file that contains the command line arguments. |
-Diff <filename> | 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. |
-BackupFile <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. |
-IncludeLogins | For backup, includes the database logins in the backup file. For restore, creates the logins from the backup file on the destination server. |
-ReportTLog | For backup, 'yes' will report 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. |
-KeepCDC | Flag to indicate whether the restore will support the Microsoft SQL Server Change Data Capture (CDC) feature. |
-KeepReplication | Preserves replication settings when restoring a published database to a server other than that on which it was created. |
-NoChecksum | Disables the validation of any checksums by the restore operation. Note: for SQL 2005 and later only. |
-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. |
-StopAt <datetime> | 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. |
-StopAtMark <mark> [-After <datetime>] | Specifies recovery to the specified <mark>, including the transaction that contains the <mark>. Note: for Log BackupType only. |
-StopBeforeMark <mark> [-After <datetime>] | Specifies recovery to the specified <mark> but does not include the transaction that contains the <mark>. Note: for Log BackupType only. |
-After <datetime> | 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. |
...