Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

sql2008 sys.symmetrics_keys

Hi,
I wonder what is use of this key when we installed sql 2008 ? it seems there in Master db ##MS_ServiceMasterKey##  and for ##MS_DatabaseMasterKey##   is the user db is encrypted ? but I don't think it use for TDE.

name                          principal_id symmetric_key_id key_length  key_algorithm algorithm_desc                                               create_date             modify_date             key_guid                             key_thumbprint                                                                                                                                                                                                                                                   provider_type                                                cryptographic_provider_guid          cryptographic_provider_algid
----------------------------- ------------ ---------------- ----------- ------------- ------------------------------------------------------------ ----------------------- ----------------------- ------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------ ------------------------------
##MS_ServiceMasterKey##       1            102              128         D3            TRIPLE_DES                                                   2012-01-07 06:24:00.507 2012-02-09 06:33:59.060 CE72EE2E-F077-4B64-B803-D11FD12E4BC6 NULL                                                                                                                                                                                                                                                             NULL                                                         NULL                                 NULL

(1 row(s) affected)









name                          principal_id symmetric_key_id key_length  key_algorithm algorithm_desc                                               create_date             modify_date             key_guid                             key_thumbprint                                                                                                                                                                                                                                                   provider_type                                                cryptographic_provider_guid          cryptographic_provider_algid
----------------------------- ------------ ---------------- ----------- ------------- ------------------------------------------------------------ ----------------------- ----------------------- ------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------ ------------------------------------ ------------------------------
##MS_DatabaseMasterKey##      1            101              128         D3            TRIPLE_DES                                                   2012-09-18 14:51:21.077 2012-09-18 14:51:21.080 8EAD9200-E2C1-4668-815F-C68F5AAF8ABA NULL                                                                                                                                                                                                                                                             NULL                                                         NULL                                 NULL

(1 row(s) affected)
0
motioneye
Asked:
motioneye
1 Solution
 
deviprasadgCommented:
MS_DatabaseMasterKey is used for database encryption and is different for each database.

MS_ServiceMasterKey is a symmetric key  used for saving linked server login passwords , credential secrets etc..

Refer:
http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/f4d292c0-72d5-4075-adf3-03427542567e/
0
 
motioneyeAuthor Commented:
so,
when we installed sql 2008 and have the lnked  server, credential saved, we should have this backup, is it correct ?
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now