If you have purchased certificates from a third-party certificate vendor, follow the instructions provided by the vendor. SQL Server 2000 permits encrypted connections over all network libraries by ...

Caution To restore an encrypted database, you need access to the certificate or asymmetric key used to encrypt that database. Without the certificate or asymmetric key, you can't restore that database ...

In SQL Server 2012 that dependency is now enforced by code. Attempting to drop a certificate currently in use on a database will fail.

Learn how to use encryption to secure your SQL DB2 database in this article. Find out how to choose the encryption method, apply the encryption key, and manage the encryption policy.