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. |