November 15, 2010 at 8:45 am
Hello any one,
I have two database [db_old] and [db_uat]. The server where the [db_uat] are located was formated and the master service key (msk) was lost. I need to use the structure in [db_uat] and use it in [db_old] without changing or deleting the certificate, master key and existing data from [db_old]. Any suggestion, steps or procedures to complete this???
Thanks,
November 15, 2010 at 9:08 am
If you have the password that was used when you created the database master key, you can use it to "introduce" the new master service key. You do that by opening the database master key with the password and then altering it to use the new service master key. The example bellow shows how to do it.
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'WritePassordHere'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
CLOSE MASTER KEY
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 15, 2010 at 9:26 am
No, I don't have the password was used to create a master key. At this point I'm not interested to use the data encrypted with the lost master service key, but I really need to use that database. Because is the latest version for one product I need to upgrade before start December, 2010. This data base just have new features, I have the same data in the production data base without the new features. Any way to put that new change in existing data base or assign new master service key to the database with lost master service key?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply