![]() ![]() When I restore c1 on the dev server, can I change its name to like c2 ( CREATE CERTIFICATE c2.After I restore c1 on the dev server, is it encrypted by master_key2? It seems I haven't touch master_key2 here.Now I restore c1 on the dev server with: CREATE CERTIFICATE c1ĭECRYPTION BY PASSWORD = 'c1_private_key_password' It's still called #MS_DatabaseMasterKey#, but it's a newly created one (let's call it master_key2). On the dev server, I created a new database master key. ![]() BACKUP CERTIFICATE c1 TO FILE = 'c:\c1.crt'ĮNCRYPTION BY PASSWORD = 'c1_private_key_password'Īfter that, I copied the three c1 backup related files to a dev server. Then I backed up c1 with the following statement. I created a certificate c1, which is encrypted by master_key1 by default. Let's say I have a production server and I have a database master key #MS_DatabaseMasterKey# (master_key1) on it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |