Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 regarding TDE backup plan

Author  Topic 

ann06
Posting Yak Master

171 Posts

Posted - 2012-10-21 : 03:57:25
hi,
after i implemented TDE on my database i need to restore the encrypted database backup on different server.

- I took backup for the encrypted database and certificate with private key as i read on some blogs.

question: do i need also to take backup of the service master key and master key and restore them on the new instance or no need?
if no need then what is the need for backing up/restoring service master key and master key commands and in which case they are used?

thanks
   

- Advertisement -