The encryption keys are of the following type.
I'm not sure that I have the private key.
I was told that you do not need the private key.
Master Key Type = Key File
ServiceMaster.Key = Key File
tde.cer = Security Certificate
tde.key = key file
Do I have what I need to decrypt the Database?
What would be the syntax?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/