[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

sql2008 sys.symmetrics_keys

Posted on 2013-01-28
2
Medium Priority
?
339 Views
Last Modified: 2013-02-22
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
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 10

Accepted Solution

by:
deviprasadg earned 2000 total points
ID: 38830041
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
 

Author Comment

by:motioneye
ID: 38830069
so,
when we installed sql 2008 and have the lnked  server, credential saved, we should have this backup, is it correct ?
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question