Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

OptionsDescription

-BackupDescription <desc>

<desc> - the description of the backup.
-BackupName <name><name> - the name of the backup.
-BackupType <type>

The backup type required.

<type> - {full, differential, log, file}.

-BckDstType <type>

The backup destination type is used for the backup.

<type> - {0, 1, 2, 3, 4, 5, 6, 7}.

where:

TypeDescription
0Single File
1Stripped Files
2Mirrored
3TSM
4Data Domain
5Amazon S3
6Azure Blob
7TSM Stripes

Note: the default value is "0".

-CompressionLevel <level>

The compression level used for the backup.

<level> - {ispeed, isize, 0, 1, 2, 3, 4}.

Note: if the compression level is not specified, ispeed is the default.

-Exclude <db_name> [<db_name> ...]

<db_name> [<db_name> ...] - one or more names of database(s) to not backup.

-InstanceName <name>

<name> - the SQL server instance name. 

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

-NoTruncate

Do not truncate the transaction log. (Log backup only).

-Overwrite

Overwrite existing archive if one exists.

Note: if this option is omitted, the default behavior is to append.

-Server <hostname>

<hostname> - the hostname of the 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).

-Verify

Verify the backup set after backup is complete.

-SectorTypePublic or Government based on Azure Sector.

Encryption Options

Encrypt your backups with the following options:

...