Loading Behavior of Encrypted Databases

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.