Add an encrypted database to an Always On availability group
Applies to: SQL Server
This article contains information about the using currently encrypted or recently decrypted databases with Always On availability groups in SQL Server.
Limitations
If a database is encrypted or even contains a database encryption key (DEK), you can't use the New Availability Group Wizard or Add Database to Availability Group Wizard to add the database to an availability group. Even if an encrypted database has been decrypted, its log backups might contain encrypted data. In this case, full initial data synchronization could fail on the database. This is because the restore log operation might require the certificate that was used by the database encryption keys (DEKs), and that certificate might be unavailable.
To make a decrypted database eligible to add to an availability group using the wizard:
- Create a full database backup of the primary database.
- Create a log backup of the primary database.
- Restore the database backup on the server instance that hosts the secondary replica.
- Restore the log backup on the secondary database.
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho