Selective Backup and Restore Rules
When performing a selective backup and restore on a table or database, observe the following rules in order for the operation to be successful.
Type |
Restore to same DBS |
Copy to same DBS |
Copy and Rename to same DBS |
Copy to different DBS |
Copy and Rename to different DBS |
|||||
|
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
DB Level |
Object Level |
Aggregate Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
JAR |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
External Stored Procedures |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Standard Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Trigger |
Yes |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
Instant or Constructor Method |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
Join Index |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |
System Join Index1 |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Macro |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Hash Index |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |
Stored Procedure |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Queue Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Table Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Table Function(Operator) |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
PPI Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
NOPI Table |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
User-Defined Data Type (UDT) |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
View |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Authorization |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Parser Contract Function |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
User Installed File (UIF) |
Yes |
Yes |
Yes |
Yes |
Yes |
No |
Yes |
Yes |
Yes |
No |
Remote Server2 |
Yes |
Yes |
Yes |
Yes |
No |
No |
Yes |
Yes |
No |
No |