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:
- * | dbname1, ..., dbnameN
- *
- Back up all databases.
- dbname
- Back up the specified database. Multiple entries are separated by commas. If separated by commas, ensure that there is no space between the comma and the name. If any database name contains blanks, enclose the database name in double quotation marks.
The following positional parameters specify the type of backup to run:
- FULL | COPY | INCRemental | DIFFerential
- FULL
- Back up the entire database, and the transaction logs, and if a successful backup is obtained, truncate the transaction logs.
- COPY
- Back up the entire database, and the transaction logs, and 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 log files, but do not truncate the log files.