Restrictions on copying a partition
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