Loading behavior differs, depending on the encryption status of both the target database and the database or transaction log being restored.
Loading Behavior | Unencrypted Target Database | Encrypted Target Database | Partially Encrypted Target Database | Partially Decrypted Target Database |
---|---|---|---|---|
Unencrypted Database Dump | Allowed. | Allowed only if using the with override clause. Dump security status is reflected in target database. | Allowed only if using the with override clause. Dump status is reflected in target database. | Allowed only if using the with override clause. Dump security status is reflected. |
Unencrypted Transaction Dump | Allowed. | Allowed. Marks the target database as partially encrypted. | Allowed. The target database retains its status as partially encrypted. | Allowed. The target database retains its status as partially encrypted. |
Encrypted Database Dump | Not allowed. | Allowed. | Allowed. Dump security status is reflected in the target database. | Allowed only if using the with override clause. Dump security status is reflected in the target database. |
Encrypted Transaction Dump | Not allowed. | Allowed. | Allowed. The target database retains its status as partially encrypted. | Not allowed. |
Partially Encrypted Database Dump | Not allowed. | Allowed. Dump security status is reflected in the target database. | Allowed. The target database retains its status as partially encrypted. | Allowed only if using the with override clause. Dump status is reflected in the target database. |
Partially Encrypted Transaction Dump | Not allowed. | Allowed. Dump security status is reflected in the target database. | Allowed. The target database retains its status as partially encrypted. | Not allowed. |
Partially Decrypted Database Dump | Not allowed. | Allowed only if using the with override clause. Dump status is reflected in the target database. | Allowed only if using the with override clause. Dump security status is reflected in the target database. | Allowed. The target database retains its status as partially decrypted. |
Partially Decrypted Transaction Dump | Not allowed. | Not allowed. | Not allowed. | Allowed. The target database retains its status as partially decrypted. |