Backup positional parameters
Positional parameters immediately follow the backup command and precede the optional parameters.
The following positional parameters specify the object
to back up:
- * | db-name1, ...,db-nameN backuptype
-
- *
- Back up all databases sequentially.
- db-name
- Back up the specified database. If separated by commas, ensure that there is no space between the comma and the database name. If any database name contains blanks, enclose the database name in double quotation marks. The database name is case sensitive.
The following positional parameters specify the type of
backup to run:
- FULL | COPY | INCRemental | DIFFerential
-
- FULL
- Back up the entire database and transaction logs, and if a successful backup is obtained, truncate the transaction logs.
- COPY
- Back up the entire database and transaction logs, do not truncate the transaction logs.
- INCRemental
- Back up the transaction logs, and if a successful backup is obtained, truncate the transaction logs.
- DIFFerential
- Back up the transaction logs but do not truncate them.