Restoring data by copying a partition has the following restrictions:

  • Both the restored backup database and the target database must be enabled for table partitioning
  • The restored backup database and target database must have identical schema for the partitions being copied
  • Partitions being copied must be allocated in the backup database
  • The tables must have indexes activated
  • Dropped objects are not supported (only deleted data can be recovered, not table definitions)
  • The restored backup database and the target database must be local (no remote connections)
  • You can execute multiple partition copy commands simultaneously only if both databases are running in multi-user mode