Restrictions on copying a partition
Restoring data by copying a partition has the following restrictions:
![*](bullet.png)
Both the restored backup database and the target database must be enabled for table partitioning
![*](bullet.png)
The restored backup database and target database must have identical schema for the partitions being copied
![*](bullet.png)
Partitions being copied must be allocated in the backup database
![*](bullet.png)
The tables must have indexes activated
![*](bullet.png)
Dropped objects are not supported (only deleted data can be recovered, not table definitions)
![*](bullet.png)
The restored backup database and the target database must be local (no remote connections)
![*](bullet.png)
You can execute multiple partition copy commands simultaneously only if both databases are running in multi-user mode