October 21, 2009 at 12:55 am
hi all,
I m having some doubts encryption as i want to implement the same in our production server
1 wat if i change the pwd of service key master will be any impact on master key.
2 if i change the master key pwd do i hav to change the pwd of certificate and symetric key
3 where does the master key and service key play an important role in encrytion.
October 21, 2009 at 2:46 am
hi experts plz reply
October 21, 2009 at 11:34 am
October 22, 2009 at 12:04 am
suppose if i hav a server A and database A which is encryted and now i wanna restore it Server B do i have to restore the service key and database key ..... wat will be the impact and how do i use this in java application.... As i want to change the Master key PWD every 3 months
October 22, 2009 at 6:00 am
When you restore a database that uses encryption features, there is only one thing you need to take care off - if the database master key (DbMK) needs a service master key (SMK) encryption, you need to regenerate this encryption. Note that this encryption is made by default when you create the DbMK, but it may be intentionally dropped, if you want tighter control of access to the encrypted data. Anyway, if you did have such SMK encryption for the DbMK, the steps to regenerate it are the following:
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
CLOSE MASTER KEY
That's it - the database encryption features should now work as when the backup was taken. Also note that it doesn't matter if you restore the database on the server where the backup was taken or elsewhere. The only thing that matters for this procedure is that you know one of the passwords protecting the DbMK.
MJ
October 22, 2009 at 11:56 pm
thkz manu but i havnt got the answer for my 1st 3 questions... and about the java in the 2nd questions......
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply