crypt

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Service master key, yes.

Database master keys, yes.

Certificates, yes.

Asymmetric and symmetric keys, no.

K. Brian Kelley
@kbriankelley

Denby Hall of Fame Points: 3120 More actions · Answer 2

could you explain the process of doing that?

Also isn't the database master key a symmetric key?

thanks

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

There are T-SQL commands (you'll find the exact syntax in Books Online):

BACKUP SERVICE MASTER KEY

BACKUP MASTER KEY

BACKUP CERTIFICATE

K. Brian Kelley
@kbriankelley

Denby Hall of Fame Points: 3120 More actions · Answer 4

Also isn't the database master key a symmetric key?

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 5

Yes, but because of its importance, you can back it up with the BACKUP MASTER KEY command.

K. Brian Kelley
@kbriankelley