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