Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql 2005 service master key question

Status
Not open for further replies.
Jun 19, 2002
294
US
Quick question regarding service master keys. We are not using any data encryption within our database. We have turned on Force Encryption (in configuration manager on the protocols for mssqlserer)

Do service master keys come into play at all here? I read something that said they were created at the time of install and something else that said they were created when you first began using encryption in the database. I guess what I am getting at is do I actually need to create a backup of these on all my new servers based on my configuration?

Thanks in advance :)
 
Dont want to detract to much from the question. So no you dont need to back these up.

Encryption and the master keys:

There is the service master key (smk if u will) which is specific to the installation.

BACKUP SERVICE MASTER KEY (Transact-SQL)

and

BACKUP MASTER KEY (Transact-SQL)

which relates to a key within a database
(dmk)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top