SQL Server Performance

TDE Restoring Database Encryption

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Apr 27, 2013.

  1. Trev256b Member

    After reading about TDE and restoring an encrypted database on another server, can anyone please answer the following?:
    1) When I restore an encrypted database on another server, I also recreate the same certificate with private key in the master database.
    1a) Do I need to create/restore anything else? I think I need to restore the master key too...
    1b) Do I need to create a master key? I think yes...
    1c) If so why, and If not why? I think because it is needed to create the necessary certificate... but I am not sure if a master key can be used for many databases...
    1d) I tried to restore on another server, but a master key already existed - can I restore an encrypted database without creating a master key if one already exists?
    1e) If an existing master key is necessary for any encrypted database to be restored, is the master key independent of all databases so numerous databases may use it?
    1f) In other words any master key must exist and does not need to have the same password as on previous server. Correct?

Share This Page