How can I duplicate a SQL Server symmetric key?

Posted by rlb.usa on Stack Overflow See other posts from Stack Overflow or by rlb.usa
Published on 2010-04-02T20:07:40Z Indexed on 2010/04/02 22:23 UTC
Read the original article Hit count: 314

We have a server with a database that has a symmetric key (Database -> Security -> Symmetric Key). We have a backup duplicate databases that we are using as a test databases, but we don't have this key in there.

How can I duplicate this symmetric key (or make a new one exactly like the old) and put it in the existing databases? It has to have the same value and key-name as the other one.

This is on SQL Server 2008.

alt text

© Stack Overflow or respective owner

Related posts about sql

Related posts about symmetric-key