I am not a DBA by anymeans so please bear with me.
I have a database that is encrypted with TDE. I do not know much about TDE but have been reading up on it. I need to export the database along with any necessary certificates required to move the database offsite to be recovered on another server. I get how to move the database using a backup. My question is how do I export the certificates properly. I read ac ouple articles and I'm not clear if its 1 certificate per server or 1 certificate per database, both, or "it depends." I successfully ran this query and exported the master key from a blog I was reading. I just need to know if there are any other certificates or problems I may run into recovering the database on the new server?
BACKUP MASTER KEY TO FILE = 'u:\MSSQL\DO_NOT_DELETE\Masterkey1'
ENCRYPTION BY PASSWORD = 'PW1234556'
this query executed and successfully exported a file which I now have backed up.
Do I need to export any other certificates?
SQL server 2008 Enterprise