Skip to main content
Version: 1.6

FASTBCP_BACKUP_RESTORE_POINT

Overview​

FastBCP reads the latest version the backup files hold:

  • --connectiontype backup_mssql (since FastBCP 1.6.7): the newest full backup, and the newest differential backup taken from it.
  • --connectiontype backup_rman (since FastBCP 1.6.8): for each datafile, the newest full or level 0 backup, and the incremental backups taken on it.

The FASTBCP_BACKUP_RESTORE_POINT environment variable changes that without touching the command. Set it to full to ignore the differential or incremental backups and read the full backup.

Syntax​

$env:FASTBCP_BACKUP_RESTORE_POINT = "full"

Configuration​

PropertyValue
Valueslatest or full, in any case. Any other value stops the run at startup with a message naming the variable
DefaultNot set: latest
Applies to--connectiontype backup_mssql (since 1.6.7), --connectiontype backup_rman (since 1.6.8)
SinceFastBCP 1.6.7
Valuebackup_mssqlbackup_rman
latestThe newest full backup among the files, and the newest differential taken from itFor each datafile, the newest full or level 0 backup, and the incremental backups taken on it
fullThe last full backup of one backup, as up to FastBCP 1.6.6. Its later differentials are ignored, and several backups in --database are refusedFor each datafile, the most recent full or level 0 backup. The incremental backups are ignored
warning

With full, an export does not read the differential or incremental backups, and so gets older rows, without any message saying so. Use it when that is what you want.

With --sourceconnectstring​

An adbc.arpemsbackup.restore_point option (backup_mssql) or adbc.arpeorabackup.restore_point option (backup_rman) in --sourceconnectstring wins over the variable.

See Also​

Copyright © 2026 Architecture & Performance.